How will you select unique values from a list of records?
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
Can %notfound return null after a fetch?
What is join view in sql?
How many subqueries can be nested in a statement?
Explain what is sql?
What is form and report?
Why is stored procedure faster than query?
How do I count records in sql?
how many columns can be used for creating index? : Sql dba
What are %type and %rowtype for?
What is sql query limit?
Can we insert data into view?
what are enums used for in mysql? : Sql dba
Why are sql stored procedures used?
what is msql? : Sql dba
How do I create a memory optimized filegroup?