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

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

What is temporary stored procedure?

0 Answers  

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

0 Answers  

What is the benefit of normalization?

0 Answers  

How to find out what is the default collation in a database?

0 Answers  

What happens if you are trying to access a schema not owned by you?

0 Answers  

How are SQL Server databases physically stored under Windows 2000?

1 Answers  

What is log shipping?

0 Answers  

Explain the storage models of OLAP?

1 Answers  

Tell me about builtinadministrator?

0 Answers  

Which autogrowth database setting is good?

0 Answers  

What language is sql server written in?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories