Interview Question

What is SELECT statement?

SELECT produces a query result from expressions and data sources.

💡 Concept ✅ Quick Revision 🗃️ SQL

Answer

SELECT retrieves rows or computes result rows from query expressions. • The select list chooses the output expressions. • FROM supplies source relations when needed. • WHERE, GROUP BY, HAVING, and ORDER BY shape the result.

💡 SQL Example

SELECT name, salary FROM employees WHERE salary >= 50000;

Result

Maya | 60000

⚡ Quick Revision

SELECT produces a query result from expressions and data sources.

←

PreviousWhat is TCL?

NextWhat is WHERE clause?

→