How will you select unique values from a list of records?
Answer Posted / os reddy
select distinct * from emp;
OR
select unique * from emp;
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is sql in oracle?
What is difference between hql and sql?
Explain the difference between rename and alias?
How do you update f as m and m as f from the below table testtable?
How many columns should be in an index?
How is a process of pl/sql compiled?
Which kind of parameters cannot have a default value in pl sql?
Is sql workbench free?
What are the commands used in sql?
What are the methods of filing?
Does sql view stored data?
How to read/write files from pl/sql?
Can we call stored procedure in function?
Explain the commit statement.
what is normalization? : Sql dba