Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 127695 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
Which is better varchar or nvarchar?
Explain the difference between rename and alias?
What are the query optimization techniques?
Why use subqueries instead of joins?
Does truncate free space?
Explain autonomous transaction.
what is the difference between truncate and drop statements? : Sql dba
Is left join and outer join same?
How do you update f as m and m as f from the below table testtable?
How do I run a program in pl sql?
what happens if you no create privilege in a database? : Sql dba
How do you write an index?
What is sqlite used for?
What is sql and explain its components?
How can I get the number of records affected by a stored procedure?
