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

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

How do you load large data to the SQL server database?

2 Answers  

what is a join and explain different types of joins? : Sql server database administration

0 Answers  

What are the differences between sql server and mysql.

0 Answers  

How to provide login information for a new odbc dsn?

0 Answers  

explain different types of jions with examples briefly?

1 Answers   Zensar,

What are the advantages of partitioning?

0 Answers  

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

0 Answers  

Can we drop user if user mapped to any logins

1 Answers  

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

What are the different normalization forms?

0 Answers