select * from employee where sal = (select * from max(sal) from emp)

can any one please send sql quries most used in applications.

Question Posted / guest

Answer Posted / guest

select * from employee
where sal =
(select * from max(sal) from emp)

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

can a table be moved to different filegroup? : Sql server administration

908

How do use Having,Group by,Group function in SQL?

1691

What is meant by Active-Passive and Active-Active clustering setup?

1067

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1020

What is Replication?

989

How can I track the changes or identify the latest insert-update-delete from a table?

912

Tell me what are the essential components of sql server service broker?

884

What is data modeling and Reterminal integrity?

1905

How do I open a .db file?

970

What is nolock hint in sql server 2008

1067

How do I know if localdb is running?

890

What does COMMIT command do?

1006

Explain data warehousing in sql server?

988

Does the order of columns in update statements matter?

857

How many types of database relationship in sql server?

992