Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 135714 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / satish parashar
After applying the unique clause all the value of column
will be sorted, But in distinct clause it only remove the
duplicacy from the table,not sorted the column value.
| Is This Answer Correct ? | 6 Yes | 15 No |
Post New Answer View All Answers
What is trigger in sql?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What does closing a cursor do?
Explain ddl statements in pl/sql?
Why is pl sql used?
What are tables and fields in the database?
What is the maximum number of rows in sql table?
What is %type in pl sql?
What is difference between rank () row_number () and dense_rank () in sql?
What are keys in sql?
What is database migration?
How do I run a sql query in pgadmin 4?
What do you understand by pl/sql cursors?
Why use stored procedures?
Is a table valued function object?
