Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

interview

home / developersection / interviews / why and how to use sql distinct clause?
Ask Question
Abhishek Srivasatava
Abhishek Srivasatava

Employee

Message

1 Answers

Abhishek Srivasatava
Abhishek Srivasatava 30 Sep 2016
Report Abuse

Distinct is used when unique result is needed from user side. It is used because after joining many tables there is chance of multiple rows for single data may come.

For example

Prsn table holding the Adhar number of person.

And we join this prsn table with prsn_buy_prod table. Let person buy 3 product so three rows will exist.

Program without distinct:

SELECT A.PRSN_ADHAR_NUM
FROM ADHAR A
LEFT JOIN PRSN_BUY_PROD B
ON A.PRSN_ADHAR_NUMNUM=B.PRSN_ADHAR_NUM_NUM 
Where A.name= ‘P Raturi’ 

Output :

987456321
987456321
987456321


For the above program 3
rows will come for the single name P Raturi.

But if use distinct along with select statement in the above program then single record will come.  

SELECT DISTICT A.PRSN_ADHAR_NUM
FROM ADHAR A
LEFT JOIN PRSN_BUY_PROD B
ON A.PRSN_ADHAR_NUMNUM=B.PRSN_ADHAR_NUM_NUM 
Where A.name= ‘P Raturi’

Output :
987456321
MindStick Training