Differences between UNIQUE and DISTINCT in select statements
Answer Posted / narendrasai
UNIQUE: it is a constraint and it was created at the time of table creation, where as
DISTINCT: it is a word used at the time of selection.
So both are same, but usage of both the words are different
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the unique index?
Is sql a case sensitive language?
How many types of relationship are there?
Is sqlexception checked or unchecked?
What are the different types of dbmss?
What has stored procedures in sql?
What is difference between sql and oracle?
What is sql resultset?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is dense_rank in sql?
What are the disadvantages of file system?
What is the purpose of cursors in pl/sql?
What are types of joins?
What is sqlite format?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?