What is the correct syntax of a query?
1Times asked
May 2026Last seen
May 2026First seen
💡 Model Answer
In SQL, a basic SELECT query follows the pattern: SELECT column1, column2, … FROM table_name WHERE condition ORDER BY column ASC|DESC LIMIT n. For example: SELECT id, name FROM users WHERE age > 18 ORDER BY name ASC LIMIT 10. The SELECT clause lists columns, FROM specifies the source table, WHERE filters rows, ORDER BY sorts, and LIMIT restricts the number of rows returned. This syntax is supported by most relational databases such as MySQL, PostgreSQL, SQL Server, and Oracle.
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers — invisible to screen sharing.
Get Assisting AI — Starts at ₹500