Distinct is used in retrieval it gives the suppressed row(ex if two rows are same it will show single row and non duplicate row) therefore distinct is the combination of suppressed duplicate and non duplicate rows. If unique constraint is given it does not take duplicate values. Unique is applied before insertion and retrival.It consists of non duplicate values. There is no difference between unique and distinct keywords apart from one difference. I have written the popular articles on SQL Questions for Cognizant Technologies as well as Infosys technologies.I have studied lot of Websites and i have experienced the SQL interview for Deloitte and come up with the set of Interview Questions for Deloitte.Deloitte is well known organization and it has some tricky interviews.I will try to cover the Tricky interview questions which will probably asked in SQL Interview of Deloitte.You need to give English versant test if you successfully completed and shortlisted from the interview.įollowing are some Interview Questions for Deloitte which will ask for SQL,PLSQL,ETL developer Interview:ġ.What is difference between unique and distinct?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |