Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 127535 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / cutepa1
yeah Manoj, this was analysed with your previous answer
itself but please try these statements and help me with
it's significance on the statements.
select unique(<clomun_name>) from <table_name>;
select distinct(<clomun_name>) from <table_name>;
| Is This Answer Correct ? | 16 Yes | 8 No |
Post New Answer View All Answers
Define union, minus, union all, intersect ?
what is the difference between truncate and drop statements? : Sql dba
what is the use of double ampersand (&&) in sql queries?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
Where can I learn sql for free?
explain commit and rollback in mysql : sql dba
Where is pl sql used?
Can dml statements be used in pl/sql?
Can we write dml inside a function in sql server?
What is the difference between joins?
What is the use of pl/sql table?
What is primary key and foreign key?
What does closing a cursor do?
what are the different type of sql's statements ? : Sql dba
How many times can we commit in a loop?
