Answer: With the help of Distinct clause,we can avoid duplicate records:-
Syntax:-
Select Distinct column_name from tbl_name;
For Example:-
select distinct project_name from project_master where project_name is not null;
Asked In: Many Interviews |
Alert Moderator