Home » SQL & PL/SQL » SQL & PL/SQL » Duplicate Empid
Duplicate Empid [message #234108] Mon, 30 April 2007 01:16 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

HI ,

I have a table .It contains empid column

It has following

empid name

1 richol

2 charles

3 michls

1 chola

2 uptip

3 arun

4 mukil



i require output in empid except emp id 4:


1

2

3

1

2

3

i want duplicate empid onlt. How can i do it?


arun
Re: Duplicate Empid [message #234113 is a reply to message #234108] Mon, 30 April 2007 01:18 Go to previous message
Littlefoot
Messages: 20893
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Group by EMPID and, using the HAVING clause, get only those EMPIDs that have COUNT > 1.
Previous Topic: ROWNUM in 10G
Next Topic: Interesting Questions
Goto Forum:
  


Current Time: Mon Dec 05 05:13:30 CST 2016

Total time taken to generate the page: 0.13373 seconds