Answer / amol dhane

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

Answer / kishore kumar

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

Answer / jayabharathi

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

Answer / reshu singhal

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

Answer / subrata sinha roy

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

Answer / anil

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

Answer / raju

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

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

Answer / kalyan

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

What are the various Isolation levels?

2 Answers   HP,

When multiple after triggers are attached to sql table, how to control the order of execution?

0 Answers  

what is sql injection?

2 Answers  

How to restore performance issues and how to check?

0 Answers  

What is de-normalization in sql database administration? Give examples?

0 Answers  

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?

1 Answers  

Describe the functionalities that views support.

0 Answers  

List some of the rules that apply to creating and using a ‘view’

0 Answers  

How can you see what type of locks used?

1 Answers  

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

If no size is defined while creating the database, what size will the database have?

0 Answers  

Using the customer, and order table in northwind database, please write a query to produce xml?

0 Answers