Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 134547 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 where clause in sql?
What is an emotional trigger?
What is package in pl sql with an examples?
What are the differences between in and exists clause?
Is a foreign key always unique?
What is the sql query to display the current date?
What does rownum mean in sql?
What do you understand by pl/sql cursors?
Does sqlite need a server?
What are pl sql data types?
Why is theta join required?
Why do we use procedures in sql?
Does pl sql work in mysql?
How do you optimize a stored procedure in sql?
Which are the different character-manipulation functions in sql?
