SQL distinct()

DISTINCT function is used to avoid the problem of duplicacy of the values in column of a given table. Hence,it's used to list only the different(distinct) values.


SYNTAX :
distinct(column_name)

Table Name 'customers'

id

name

age

city

bill

1Tom34Paris5300
2Jhony51London 400
3Ram64Delhi20000.7
4Simon23Portland32.65



Online Execute/Compile

Quantitative Aptitude
Reasoning
Programming
Interview