Simple SQL statement help needed?

Question

How do I write this SQL statement such that i could get that output?

"Getting the 4 latest categories of the latest updated news."

==SQL Table==
ID CATEGORY
76 Sports
75 Sports
74 Entertainment
73 Sports
72 Business
71 World
70 Business

==OUTPUT==
Sports
Entertainment
Business
World

There are still some more other data in the SQL Table such as news title, date etc.

I tried "Select distinct category order by id DESC" but it not is not logically right.

I just need the sql statement.

Any kind soul to help me?? thanks!!

=======================================

not logically right refers to it will get the distinct categories but from the bottom despite stating to arrange by ID.

==SQL Table==
76 Sports
.
.
.
6 Sports
5 Entertainment
4 Sports
3 Business
2 World
1 Business

==OUTPUT==
Entertainment
Sports
World
Business

Answer 1

select category from (

select category, max(id) mk from YourTable group by category

) x order by mk desc

Answer 2

SELECT TOP 4 From [tablename] order BY ID desc

Answer 3

you do not point out which style of sq. you're utilising. MySQL: decide on type from table order by utilising identity desc decrease 4 group by utilising type Transact-sq.: decide on precise 4 type from table order by utilising identity desc group by utilising type

Answer 4

could u restate this question