Answer / satheesh

SELECT * FROM EDUCATION E1 WHERE ROWID>(SELECT MIN(ROWID)
FROM EDUCATION E2 WHERE E1.EMPID=E2.EMPID)

Answer / sirisha

select id,count(id) from Education group by id having count(id)>1

Answer / aditi yadav

SELECT *FROM Employee
WHERE JoiningDate >= DATEADD(M, -2, GETDATE())

Answer / keerthana

select Student_Name,Dgree from Education
group by (Student_Name,Dgree) having count(*) > 1;

Answer / karthik

i think ths will work!
select * from table_name where rowid in (select max
(rowid) from table_name groupby duplicate_field_name);

Answer / lavanya

SELECT COUNT(*), <COLUMN_NAME> FROM EDUCATION GROUP BY
<COLUMN_NAME>

Answer / guest

unionall

Answer / dawood

SELECT COUNT(EMPNO),ENAME FROM EDUCTION
GROUP BY ENAME;

Answer / harish

select * from education where rownum < ( select max(rownum)
from education group by <column_name> )

What is the difference between subquery and correlated query?

0 Answers  

Can we create table in function?

0 Answers  

explain what is mysql? : Sql dba

0 Answers  

List the different type of joins?

0 Answers  

What is recursive stored procedure?

0 Answers  

What do you think about pl/sql?

0 Answers  

What is minus?

0 Answers  

What is foreign key and example?

0 Answers  

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 Answers   Deloitte, Ness Technologies,

Which is the correct statement about truncate and delete?

0 Answers  

What are local and global Indexes and where they are useful.

0 Answers  

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

0 Answers   MCN Solutions,