HomeОбразованиеRelated VideosMore From: Durga Software Solutions

Oracle || Oracle Session-6 by Dinesh

89 ratings | 32602 views
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Html code for embedding videos on your blog
Text Comments (12)
Anil Kumar (4 months ago)
thank you very much sir, these videos are very useful a lot especially the theory and line by line explanation is good
Pratik Kumar (1 year ago)
sir your lectures are better than nptel vedios............
Navin nipath (1 year ago)
exactly bro
Kumar Ravi Ranjan (1 year ago)
hello sir. when we use -order by gender. How it will recognise which one to display first male or female?
Shivam Sehgal (1 year ago)
It will recognize by alphabetic order. So, f comes first before m, therefore it will display female first.
Kovvuri Varma (1 year ago)
Chhotu Dhankhar (1 year ago)
what if we have DID DNAME LOCATION d1 sales blr d1 sales hyd d2 production delhi in this case how can we apply distinct keyword on DID and LOCATION on same time, because LOCATION for d1 is blr and hyd but DID for both is same. please explain .............
Shivam Sehgal (1 year ago)
Both are different, Here, in your example, one d1 is relating to blr and another one is relating to hyd, so thats y the O/P would be same
Mohamd zouin (1 year ago)
hey Professor , I think the right syntax for distinct is : SELECT DISTINCT column1, column2, ... FROM table_name; no parenthesis . :)
suhasbn belur (2 years ago)
Ramesh sir , if i put the distinct on multiple columns duplicate elimination is not working i am using select DISTINCT RSRC_TYP_NM,ENTRPRS_FAC_ID from rsrvbl_rsrc ; here RSRC_TYP_NM has duplicate data if i run the this query its displaying duplicate data
Mohamd zouin (1 year ago)
here is the solution select distinct entrprs_fac_id , rscr_typ from your table ; in this order i will display unique second column . hope it works
Kishan jaiswal (1 year ago)
try to put the column names in small bracket like (col1,col2...colN)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.