i want only duplicates rows from coloumn
ex. emp_id(colomn name)1,1,2,3,3,4,5,5.
so i want only duplicates no.
Answers were Sorted based on User's Feedback
Answer / kumar.t
Select Emp_Id, Count(Emp_Id) From Employee As Emp
Group By Emp_Id
Having Count(Emp_Id)>1
By
Kumar
Is This Answer Correct ? | 17 Yes | 2 No |
Answer / chinna_g
You have 'emp' table with empid,empname,empsal.
With values:
1 row:1,'hhh',10000
2 row:2,'nnn',10000
3 row:3,'vvv',15000
4 row:4,'jjj',10000
A)
In this table you have sal column 10000 repeating 3 times
in the table, if you want to retrieve the repeated values
i.e. the salary column with 3 times to be displayed in the
following query:
"select empsal from emp where empsal in(select empsal from
emp group by empsal having count(empsal)>1);"
Is This Answer Correct ? | 9 Yes | 1 No |
Answer / v rajkumar
select Emp_Id from Employee group by Emp_Id having count(*)
>1
Is This Answer Correct ? | 1 Yes | 0 No |
hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?
7 Answers Google, TCS, Unisys,
Which command executes the contents of a specified file?
What are the different editions available in sql server 2000?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What is sql view?
What happens if null values are involved in arithmetic operations?
How do I install only the client tools of sql server 2000?
How to write character string constants or literals in ms sql server?
What is shared lock?
What is the xml datatype?
What is self join in sql server joins?
Explain about SQLOS?