A database administrator needs a list of unique cities where students live, without any duplicate rows or counts. Which SQL query is the simplest and correct choice?

Question

Computer Science · SQL Queries

Verified Solution4 OptionsUpdated: October 2026👁️1 View

Share:

Correct answer

SELECT DISTINCT city FROM students;

Save this question and verified answer as a clean study sheet with live clickable link.

👥

Challenge your peer aspirants on WhatsApp or Telegram to solve this question!

Online Test Series

Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.

Chapter Practice

Want more practice questions on SQL Queries?

Solve complete topic-wise tests with detailed solutions on GkGet.

Recommended practice questions in Computer Science · SQL Queries

Who among the following founded the 'Forward Bloc'?

Which of the following statements regarding the Harappan Civilization is NOT correct?

Which ruler is generally credited with unifying much of Northern India under a single empire for the first time?

Answer 1

SELECT UNIQUE city FROM students WHERE city IS NOT NULL;

Answer 2

SELECT city FROM students ORDER BY city;

Answer 3

SELECT DISTINCT city FROM students;

Answer 4

SELECT city FROM students GROUP BY city HAVING COUNT() > 1;

Related Practice Questions