DISTINCT k ...
Site Language: English
Terms and Conditions
DISTINCT keyword is used to:
Order returned records in ascending order
Remove repeated values
Order returned records in descending order
Delete specified data from the database
Get an explanation when it's available:
Given the cars table: color ----- blue red null blue ...
What is DISTINCT keyword used for in SQL?...
Given a PLAYERS table with following columns and constraints: -------...
What data will the following query return: SELECT DI...
Which of the following keywords are used with sub-queries only?...
Given the nums table: id | num ---+---- 1 | 1 2 ...
Login to learn SQL
Read more about
Suppose table A has 5 rows and table B has 6 rows. You perform a c...
Suppose table A has 7 rows and table B has 3 rows. You perform a c...
What is the proper syntax of the keyword LIMIT to display 5 result...
What is the proper syntax of the keyword LIMIT to display 8 result...
What is an alternate way of writing the following statement: WHERE "...
Choose correct clause: SELECT CountryCode, COUNT(*) FROM City GROUP ...
Sign Up Now
Subscribe for future quizzes