How will you select unique values from a list of records?
Answers were Sorted based on User's Feedback
Answer / os reddy
select distinct * from emp;
OR
select unique * from emp;
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / eshwer
by using min(rowid) or max(rowid). its like deleting duplicate values.
select columns from emp where rowid not in[in] (select maxrow(id) from emp group by columns);
Is This Answer Correct ? | 0 Yes | 0 No |
What is spool?
Is inner join same as self join?
How do you exit in sql?
What is difference between function and trigger?
How to get each name only once from an employee table?
what are the forced views
What is trigger price?
what are the type of locks ? : Sql dba
how to escape special characters in sql statements? : Sql dba
how to use case expression? : Sql dba
how to create table with in the procedure or function?
What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..
1 Answers Metric Stream, Polaris,