Structured Query Language (SQL) · Class 12 · CBSE · Science Computer Science
Which SQL query displays each different city name only once from the relation STUDENT?
Practice question from Structured Query Language (SQL) (Class 12 · CBSE · Science Computer Science), with the correct answer and a step-by-step solution.
easy · MCQ · Q-A66CEE
Which SQL query displays each different city name only once from the relation STUDENT?
- A.SELECT DISTINCT City FROM STUDENT;Correct answer
- B.SELECT UNIQUE City FROM STUDENT;
- C.SELECT City FROM STUDENT GROUP City;
- D.SELECT DIFFERENT City FROM STUDENT;
Solution
The DISTINCT keyword removes duplicate values from the result. Therefore, SELECT DISTINCT City FROM STUDENT; displays every city only once.
More from Structured Query Language (SQL)
- A relation named EMPLOYEE has the columns EmpID, Dept, and Salary. Which query displays the departments whose average salary is greater tha…
- A relation named STUDENT has the columns RollNo, Name, and Marks. Write an SQL query to display the Name and Marks of students whose Marks…
- Which SQL query correctly adds a column named Email to the STUDENT table?
- A database has CUSTOMER(CustID, Name) and ORDERINFO(OrderID, CustID, Amount). Which query displays the names of customers who have not plac…
Practise more Computer Science
Sign up free for adaptive practice on this chapter, with instant feedback and hints on every question.
Start practising freeFree to start · No credit card needed