Answer / justus

create table emp

empid empname
----- --------
101 a
102 b
103 a
104 c
105 a

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

Answer / sivasiva

create table emp

empid empname
----- --------
101 a
102 b
103 a
104 c
105 a
select empid from emp groupby empid,empname having count>1

Answer / satishkulala

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

Answer / rajesh.a

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

Answer / jaleel ahamed s

create table emp (empid int,empname varchar)

insert into emp values (101,'a')
insert into emp values (102,'b')
insert into emp values (103,'a')
insert into emp values (104,'c')
insert into emp values (105,'a')

select * from emp

SELECT EmpName,Count(EmpID)Cnt From Emp Group By EmpName
Having Count(EmpName) > 1

Answer / ashish jain

create table emp

empid empname
----- --------
101 a
102 b
103 a
104 c
105 a

select empname from emp where count(empname)>1

How to delete an existing database user?

0 Answers  

How to get number of days in a given year?

4 Answers   ADP,

List out the differences between global and local temp tables in sql server?

0 Answers  

Explain user defined views?

0 Answers  

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

0 Answers   Genpact,

How to read data in a table with "select" statements?

0 Answers  

Tell me can we use custom code in ssrs?

0 Answers  

What is the largest component inside a field?

0 Answers  

What are the aggregate and scalar functions?

0 Answers  

How make remote connection in database?

1 Answers  

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

0 Answers  

From where can you change the default port?

3 Answers