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

How to encrypt data between dialogs?

0 Answers  

Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

How many types of attribute relationships are there? : sql server analysis services, ssas

0 Answers  

How does normalization work?

0 Answers  

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

0 Answers  

When would you use a before or after trigger?

0 Answers  

How do I find query history in sql server?

0 Answers  

What are transactions and its controls?

0 Answers  

Explain nested trigger in sql?

0 Answers  

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

2 Answers  

How would you choose between a clustered and a non-clustered index?

0 Answers  

What is the security principal at the server level that represents your session?

0 Answers