Informatics Practices
In SQL, which command is used to SELECT only one copy of each set of duplicable rows ?
- SELECT DISTINCT
- SELECT UNIQUE
- SELECT DIFFERENT
- All of the above
SQL Queries
2 Likes
Answer
SELECT DISTINCT
Reason — The SELECT DISTINCT statement is used in SQL to return only unique (distinct) values within the result set. It removes duplicate records, ensuring that each row in the result set is unique.
Answered By
2 Likes
Related Questions
The …………… clause of SELECT query allows us to select only those rows in the result that satisfy a specified condition.
- Where
- from
- having
- like
Consider the following query :
SELECT name FROM class WHERE subject ............... NULL;Which comparison operator may be used to fill the blank space in above query ?
- =
- LIKE
- IS
- IS NOT
Which of the following types of table constraints will prevent the entry of duplicate rows?
- Unique
- Distinct
- Primary Key
- NULL
Ravisha has stored the records of all students of her class in a MYSQL table. Suggest a suitable SQL clause that she should use to display the names of students in alphabetical order.
- SORT BY
- ALIGN BY
- GROUP BY
- ORDER BY