Answer / mohit kumar singhal

Select emp.empname, emp.salary from emp right outer join (
select empname, salary from emp
group by empname, salary
having count(empname) > 1) as tbl
on emp.empname = tbl.empname

Answer / murtaza

select empname,salary from A
where empname IN ('A','B');

Answer / enis ertem

Select emp.empname, emp.salary from employee emp join (
select empname, salary from employee emp
group by empname, salary
having count(empname) > 1) as tbl
on emp.empname = tbl.empname

Answer / zaheer abbas

select empname ,salary
from A

where salary <= 2000
order by empname

Answer / rajkumar

select*from emp where empname in ('A','B') order by empname

Answer / vinay

select empname , salary
from A
where empname in (select name from A group by empname
having count(empname ) > 1)
order by empname

Answer / anand

select empname,salary from tableA where(empname in (select
empname from tableA group by empname having count(empname)
>1))order by empname

Answer / kuntal

select * from A where empname in (select empname from A
group by empname having COUNT(*)>1)

Answer / goutam dey

select empname,salary from tableA
groupby empname
having count(empname)>1

Answer / inderpal

Select empname, salary from A order by empname

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

0 Answers  

What is the default schema of your login session in ms sql server?

0 Answers  

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

0 Answers  

What is normalization and what are the different forms of normalizations?

2 Answers  

What are the authentication modes in SQL Server?

4 Answers   IBM, iSmart,

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

What are different backups available in sql server?

0 Answers  

What is the difference between ‘having’ clause and a ‘where’ clause?

0 Answers  

How to insert data into an existing table?

0 Answers  

What are the different Topologies in which Replication can be configured?

0 Answers  

Explain transaction server isolation?

0 Answers  

can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 Answers