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

What is the difference between clustered index and primary key?

0 Answers  

How to download and install microsoft .net framework version 2.0?

0 Answers  

What is Dependency Injection and provide example?

0 Answers  

What is indexing and its types?

0 Answers  

Can we add our custom code in ssis?

0 Answers  

What is subquery in sql?

0 Answers  

What is meant by referential integrity?

0 Answers   Blue Star,

How to select nth record from a table?

13 Answers   DELL, Microsoft, Ramco,

Why union all is faster than union?

0 Answers  

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

0 Answers  

Why the trigger fires multiple times in single login?

0 Answers  

What's the purpose of Stored Procedure?

6 Answers   Wipro,