Top 3 students by mark?

Question

Accepted Answer

```sql
-- MySQL / PostgreSQL
SELECT name, mark FROM Students ORDER BY mark DESC LIMIT 3;
-- SQL Server
SELECT TOP 3 name, mark FROM Students ORDER BY mark DESC;
-- Oracle
SELECT name, mark FROM Students WHERE ROWNUM  ```

## Итог

Key takeaway for interview: Top 3 students by mark?