How will this command be executed or how else can I set it?

Question

SQL

SELECT TOP 10 FROM Themes WHERE Area_AreaId=areaid ORDER BY DateUpdate DESC
I would like to select records from the database with the corresponding id, order them by date in reverse order and take the last 10 - done to display the last 10 updated topics
Is the command written correctly? Also what will be if basically these 10 records will not be?

Answer 1

Specify at least bd?
And then in
mySQL: limit
Oracle: rownum
MsSQL: top 10
....
The logic is correct. If there is no 10. So there will be less / there will be nothing

Answer 2

Is there a TOP 10 team? O_O
order by DateUpdate desc limit 10- limit is just designed to display a certain amount