saket kumar singh

• Oct 12th, 2005

 

using rowid

Atanu Basu

• Jun 23rd, 2006

 

LET THINK "EMP" IS A TABLE AND "EMP_CODE" IS THE KEY ATTRIBUTE

SELECT * FROM EMP WHERE ROWID NOT  IN 

                              (SELECT MIN(ROWID) FROM EMP  GROUP BY EMP_CODE) 

venkat balabadruni

• Dec 4th, 2006

 

select * from emp where rowid not in ( select min(rowid) from emp group by ename);

vara

• Nov 18th, 2007

 

select * from emp a where rowid >(select min(rowid) from emp b where a.empno = b.empno)

swetashashi

 Profile Answers by swetashashi 

• Feb 10th, 2010

 

SELECT emp_name,count(emp_name) AS cnt
FROM employee
GROUP BY emp_name
WHERE cnt>1