Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

An employee table, with the columns id, name, sal and dob.
Query to select emp names of all highest salaries(there are
4-5 people having the same salary which happens to be the
highest).









Question Posted / swathi

Answers were Sorted based on User's Feedback



An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest..

Answer / amol dhane

Select * From (Select emp1.*, dense_rank () Over (Order By
sal asc) Salary_Order From employee emp1)emp2 Where
Salary_Order = 1

Is This Answer Correct ?    10 Yes 1 No

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest..

Answer / kishore kumar

Select ename from emp where sal=(select max(sal) from emp)

Is This Answer Correct ?    13 Yes 5 No

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest..

Answer / jayabharathi

Select empname,salary from emp where salary=(select
max(salary) from emp)

Is This Answer Correct ?    6 Yes 0 No

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest..

Answer / reshu singhal

select name from employee where sal = (select max(sal) from
employee)

Is This Answer Correct ?    4 Yes 1 No

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest..

Answer / subrata sinha roy

SELECT NAME ,SAL FROM employee WHERE
SAL=(SELECT MAX(sal)from employee )

Is This Answer Correct ?    4 Yes 2 No

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest..

Answer / anil

select name,sal from employee where sal in(select top 5 sal from employee order by sal desc)

Is This Answer Correct ?    7 Yes 7 No

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest..

Answer / raju

SELECT NAME ,SAL FROM employee WHERE
SAL=(SELECT MAX(sal)from employee )

Is This Answer Correct ?    0 Yes 0 No

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest..

Answer / swathi

I have just mentioned that 4-5....but ingeneral when you
donno how many employees are there with highly paid
amount...then how are you going to write the query

Is This Answer Correct ?    0 Yes 2 No

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest..

Answer / kalyan

select name,max(sal) from emp group by name

Is This Answer Correct ?    6 Yes 8 No

Post New Answer

More SQL Server Interview Questions

What is RAID? What are the different types of RAID configurations?

0 Answers   Flextronics,

What do you do in data exploration

0 Answers   EXL,

How to execute the cursor queries with "open" statements?

0 Answers  

can any body tell me how to know the password of current user in sql server

0 Answers   Crea, HCL,

What is ACID Property of Transaction?

10 Answers  

How to delete an existing database user?

0 Answers  

Can group functions be used in the order by clause in ms sql server?

0 Answers  

Explain what is log shipping?

0 Answers  

Can we write trigger for view?

0 Answers  

Explain for xml explicit mode?

0 Answers  

How to create stored procedures with parameters in ms sql server?

0 Answers  

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories