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

Define compound operators?

967

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

1010

How to execute multiple stored procedures at one time in sql server?

1063

List some major differences between triggers and stored procedures?

980

Give me any three differences between Truncate and Delete.

1156

What are the 2 types of classifications of constraints in the sql server?

1182

Which language rdl files made of?

141

How to include text values in sql statements?

1098

How to delete duplicate rows?

1039

What is the security model used in sql server 2005?

1068

What are the different types of normalization?

1221

What is the need for group functions in sql?

1153

Why I can not enter 0.001 second in date and time literals in ms sql server?

1109

What is repeatable read?

1093

What is the difference between clustered index and primary key?

970