Interested to Buy Any Domain ? << Click Here >> for more details...
How will you select unique values from a list of records?
- 7 Answers
- 17839 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are analytical functions in sql?
What is sql engine in oracle?
Explain table and field in sql?
what is a composite key ? : Sql dba
how to use like conditions? : Sql dba
What is record data type?
Which one is faster ienumerable or iqueryable?
What is the plv (pl/vision) package offers?
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
Why do we need sharding?
What are few of the schema objects that are created using PL/SQL?
What is thread join () in threading?
what is the difference between nested subquery and correlated subquery?
what is timestamp in mysql? : Sql dba
What is view explain with example?
