How to use distinct key word in query

Answer 1

👉select distinct names from employee;

// note : here table is employee , names is one of the field /key/column of this employee table , if u want to view all names of people but different only .. i mean not same name displayed again ... then u can use distinct in front of the name field

👉select distinct name , roll no from student ;

//note : here table is student and u want to see names of students but distict names only with roll no. also ... so u can use it

//hope u got it ☺

Answer 2

👉 Column_ID
2
2
2
3

consider the above column

SELECT DISTINCT Column_ID FROM TABLE_NAME

output:
2
3