how will I find the duplicate rows count from employees
tablein oracle.
Answer Posted / avik ganguly
select * from emp a where rowid = (select max(rowid) from
emp where empno = a.empno group by empno having count(*) >1)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to use timestamp datatypes
What are the main phases of database development?
What is an application role and explain a scenario when you would use one?
Which four data types cannot be used as a return type from a user-defined function?
Explain about query and reporting.
What are the three basic rules which are to be followed for the relational model of the database?
How can you log an error to the server event log from a stored procedure?
Why does this query return 0?
How to generate OIDS
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
What is the maximum length of an extended property?
Explain about xml databases?
Explain about relational database management systems?
How is data stored in dbms?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?