Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 134587 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / gourvendra singh
Buddy i dont found any difference in using distinct and
unique in the select statement, as both are performing same
operation in the select statement, almost every diff you
have discussed i want to add one that is u cant use
distinct in the create whereas unique u can.
| Is This Answer Correct ? | 19 Yes | 9 No |
Post New Answer View All Answers
what is the difference between cluster and non cluster index? : Sql dba
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What packages are available to pl/sql developers?
Can a trigger call a stored procedure?
What does pl sql developer do?
How do I kill a query in postgresql?
What is tuple in sql?
How is use pl and sql?
Why are indexes and views important to an organization?
what is the command used to fetch first 5 characters of the string? : Sql dba
What mean sql?
How do you pronounce sql?
Show how functions and procedures are called in a pl/sql block.
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
