Interested to Buy Any Domain ? << Click Here >> for more details...
How will you select unique values from a list of records?
- 7 Answers
- 17548 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 is secondary key?
Which is better varchar or nvarchar?
What is schema in sql example?
What is sql resultset?
How do I turn a list into a table?
What is the difference between microsoft access and sql?
What is count * in sql?
what is the functionality of the function htmlentities? : Sql dba
Why use triggers in sql?
List the various privileges that a user can grant to another user?
How can you load multi line records? : aql loader
Explain the order of sql statement execution?
How to display the records between two range in Oracle SQL Plus?
What is the max nvarchar size?
Why plvtab is considered as the easiest way to access the pl/sql table?
