Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 134988 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 is a rank in sql?
Which operator is used in query for pattern matching?
what is user defined functions? : Sql dba
Is sql between inclusive?
Explain correlated query work?
How to run sql*plus commands in sql developer?
what is the difference between truncate and drop statements? : Sql dba
What is fmtonly in sql?
Name the different types of indexes in sql and define them.
What is faster join or subquery?
how to include character strings in sql statements? : Sql dba
Is primary key is clustered index?
How to know the last executed procedure?
What is Collation Sensitivity ? What are the various type ?
What are the disadvantages of not performing database normalization?
