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 use of tempdb? What values does it hold?

0 Answers   Abacus,

What is Schema in Database?

1 Answers   Cap Gemini,

What is the difference between views and stored procedures? Can we have input parameters for views?

6 Answers  

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

How secure is sql server database?

0 Answers  

What is precedence constraint?

0 Answers  

How to create Clustered Primary Key to table?

2 Answers  

How do you delete duplicate rows in sql server?

0 Answers  

How to find the date and time of last updated table?

3 Answers  

Define msdb database?

0 Answers  

Can you leave a union at any time?

0 Answers  

What is nolock hint in sql server 2008

0 Answers   HCL,