Question 31
Which SQL statement is used to retrieve rows from a table?
SELECT is the SQL query statement used to retrieve data from one or more tables or other query sources.
Which SQL statement is used to retrieve rows from a table?
SELECT is the SQL query statement used to retrieve data from one or more tables or other query sources.
Which clause specifies the source table or tables in a basic SELECT query?
The FROM clause identifies the table or table expressions from which the query obtains rows.
Which clause sorts the rows returned by a SQL query?
ORDER BY sorts the result set by one or more expressions, in ascending order by default unless DESC is specified.
In SQL, which keyword is commonly used to limit rows after sorting or filtering in systems such as PostgreSQL and MySQL?
LIMIT restricts the number of rows returned in systems such as PostgreSQL and MySQL; other DBMSs may use FETCH FIRST or TOP.
Which clause is used to group rows that have the same values in specified columns?
GROUP BY forms groups of rows with equal grouping-expression values, commonly for aggregate calculations.