Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 135527 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
What are triggers in sql?
What is cursor status?
What is difference between group by and partition by?
Can we use two order by clause in query?
explain mysql aggregate functions. : Sql dba
Which command is used to delete a trigger?
Can we join two tables without common column?
What is cte sql?
What are the three pl sql block types?
how to include numeric values in sql statements? : Sql dba
What is left inner join in sql?
Is nosql relational?
What is indexing in sql and its types?
How do I view a sql trace file?
What is pl sql code?
