select count(*),empname from emp group by empname having count(*)>1

How reterive duplicate value in SQL?

Question Posted / rajesh.a

Answer Posted / rajesh.a

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is difference between getdate and sysdatetime in sql server 2008?

1099

Explain about integration services of Microsoft SQL server?

1085

Is it possible in sql table to have more than one foreign key?

1092

What is nonclustered index on computed columns?

998

How to drop existing views from a database in ms sql server?

1147

What is indexing explain it with an example?

1070

How to write an inner join with the where clause in ms sql server?

1164

What is field with example?

976

Explain what is lock escalation?

1110

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1175

What are the different editions available in sql server 2000?

1112

What happens if null values are involved in arithmetic operations?

1049

How to sort the query output with order by clauses in ms sql server?

1070

Is ssrs support other database except ms sql server?

142

What is the difference between ddl and dml?

1097