Interested to Buy Any Domain ? << Click Here >> for more details...
How will you select unique values from a list of records?
- 7 Answers
- 17781 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 index example?
Explain dml and ddl?
What type of join is sql join?
what are the advantages a stored procedure? : Sql dba
How many types of triggers exist in pl/sql?
What is a primary key called that is made up of more than one field?
what are the different type of sql's statements ? : Sql dba
What language is oracle sql developer?
Is primary key a clustered index?
What are inbuilt functions in sql?
What normalization means?
What is the command used to fetch the first 5 characters of a string?
What is a .db file?
Explain unique key in sql.
Can a commit statement be executed as part of a trigger?
