Q. How can you select the top 5 rows in a table?

  • (A) SELECT * FROM table LIMIT 5;
  • (B) SELECT TOP 5 FROM table;
  • (C) SELECT LIMIT 5 FROM table;
  • (D) SELECT FIRST 5 FROM table;
πŸ’¬ Discuss
βœ… Correct Answer: (A) SELECT * FROM table LIMIT 5;
Explanation: `LIMIT 5` returns the first 5 rows from the result set.
Explanation by: Mr. Dubey
`LIMIT 5` returns the first 5 rows from the result set.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
106
Total Visits
πŸ“½οΈ
1 y ago
Published
πŸŽ–οΈ
Mr. Dubey
Publisher
πŸ“ˆ
93%
Success Rate