Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 135715 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
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
What is sql used for?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
How do I remove duplicates in two columns?
Is sql similar to python?
Why do we use %rowtype & %type in plsql?
Differentiate between sga and pga.
What is java sql package?
How do I know if I have sql express or standard?
How do you add a column to a table?
What does trigger mean in psychology?
How do I run a query in pl sql developer?
Is left join and outer join same?
What are the triggers associated with image items?
Can we create table inside stored procedure?
