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 are the different types of joins and what does each do?

2 Answers  

How to select all columns of all rows from a table with a select statement in ms sql server?

0 Answers  

How to display a past time in days, hours and minutes?

0 Answers  

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  

two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?

5 Answers   CSE,

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

What is store procedure? When do you use?

0 Answers  

What does the on delete cascade option do?

0 Answers  

How can i change the column name.

13 Answers   HCL, Yardi Software,

If a stored procedure is taking a table data type, how it looks?

1 Answers  

What are the differences between left join and inner join in sql server?

0 Answers  

How sql server executes a statement with nested subqueries?

0 Answers