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
1	Tom	34	Paris	5300
2	Jhony	51	London	400
3	Ram	64	Delhi	20000.7
4	Simon	23	Portland	32.65

Online Execute/Compile
select distinct(age) from customers ;

: Scanftree

sql

sql-distinct

SQL

DQL :Data Query

DML :Data Manipulation

DDL :Data Definition

TCL :Transaction Control

DCL :Data Control

SQL others

SQL Function

SQL distinct()

SYNTAX :

Table Name 'customers'

id

name

age

city

bill

Aptitude / Reasoning / Interview

Physical education & sports