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 |
How do you know if a relationship is 2nf?
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance
pl/sql testing means what ...... explain process how to find pl/sql bugs
What is pl sql commands?
Is merge a dml statement?
Are pl sql variables case sensitive?
How to look at the current sql*plus system settings?
1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?
What are different types of indexes?
What is a common use of group by in sql?
What is pl sql quora?
When the mutating error will comes? and how it will be resolved?