what eliminate duplicate without using roenum and not
Answer Posted / sathish
Use Group clause and having count < 2
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is the basic form of sql query?
What is time based sql injection?
How are sql commands classified?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
Where not exists in sql?
What is memory optimized table?
What are sql functions? Describe the different types of sql functions?
When do we use triggers?
How can get second highest salary in sql?
What is triggering circuit?
What is difference between hql and sql?
Can we update views in sql?
Is primary key always clustered index?
Is sql sequential or random?
What are all the different types of indexes?