Question:
................ keyword is used in SELECT statement along with column name to display duplicate values once in the result of an SQL query.
................ keyword is used in SELECT statement along with column name to display duplicate values once in the result of an SQL query.
Show Hint
Use DISTINCT to retrieve unique values in SQL query results.
Updated On: Jul 14, 2025
Show Solution
Verified By Collegedunia
Solution and Explanation
In SQL, the DISTINCT keyword is used in a SELECT statement to remove duplicate records from the result set.
When selecting data from a column that may contain repeated values, DISTINCT ensures that only one occurrence of each value appears in the output.
For example, the query SELECT DISTINCT country FROM users; will return a list of unique countries from the users table.
DISTINCT applies to the entire row if multiple columns are specified.
This is useful in reporting and filtering scenarios where duplicates are not desired.
When selecting data from a column that may contain repeated values, DISTINCT ensures that only one occurrence of each value appears in the output.
For example, the query SELECT DISTINCT country FROM users; will return a list of unique countries from the users table.
DISTINCT applies to the entire row if multiple columns are specified.
This is useful in reporting and filtering scenarios where duplicates are not desired.
Was this answer helpful?
0
0
Top CBSE CLASS XII Information Technology Questions
- DBMS stands for ................ .
- All Java statements must end with a/an ................ .
- ................ is a language that is used to manage data stored in an RDBMS.
- In relational models, a ................ is called a relation.
- IRCTC online portal for booking train tickets stands for:
(A) International Railway Catering and Tourism Corporation
(B) Indian Railway Controlling and Transport Corporation
(C) Indian Railway Catering and Tourism Corporation
(D) International Railway Controlling and Transport Corporation
View More Questions
Top CBSE CLASS XII SQL Questions
- Kritika did not use ASC or DESC keyword with ORDER BY clause. By default in which order will the result of the query be displayed?
- What is the purpose of % and _ (underscore) characters used with LIKE operator in SQL?
- Explain the use of any three aggregate functions in SQL.
- Consider the given table GARMENT:
+--------+--------------+------+--------+-------+ | GCODE | GNAME | SIZE | COLOUR | PRICE | +--------+--------------+------+--------+-------+ | 111 | TShirt | XL | Red | 1400 | | 112 | Jeans | L | Blue | 1600 | | 113 | Skirt | M | Black | 1100 | | 114 | Ladies Jacket| XL | Blue | 4000 | | 115 | Trousers | L | Brown | 1500 | | 116 | Ladies Top | L | Pink | 1200 | +--------+--------------+------+--------+-------+
Write SQL commands for the following: (a) To display names of those garments that are available in ‘L’ size.
(b) To change the colour of garments with code as 115 to “Orange”.
(c) To add a new row with the following data:
GCODE = 117, GNAME = Kurta, SIZE = M, COLOUR = White, PRICE = 1000
(d) To remove the column ‘COLOUR’ from the table ‘GARMENT’.
Top CBSE CLASS XII Questions
- 2, b, c are in A.P. and the range of determinant $\begin{vmatrix}1&1&1\\ 2&b&c\\ 4&b^{2}&c^{2}\end{vmatrix}$ is [2, 16]. Then find range of c is
- A boy of mass 50 kg is standing at one end of a, boat of length 9 m and mass 400 kg. He runs to the other, end. The distance through which the centre of mass of the boat boy system moves is
- A capillary tube of radius r is dipped inside a large vessel of water. The mass of water raised above water level is M. If the radius of capillary is doubled, the mass of water inside capillary will be
- A circular disc is rotating about its own axis. An external opposing torque 0.02 Nm is applied on the disc by which it comes rest in 5 seconds. The initial angular momentum of disc is
- A circular disc is rotating about its own axis at uniform angular velocity \(\omega.\) The disc is subjected to uniform angular retardation by which its angular velocity is decreased to \(\frac {\omega}{2}\) during 120 rotations. The number of rotations further made by it before coming to rest is
View More Questions