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

How many types of built in functions are there in sql server 2012?

907

What is the name of reporting services config file and what’s it’s used for?

145

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

906

What is for xml in sql server?

1041

What are scheduled tasks in sql server?

1057

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

979

What is the openxml statement in sql server?

1050

Define normalisation?

1093

What do you mean by subquery?

1068

How to call stored procedure using http soap?

1053

What is difference between rollback immediate and with no_wait during alter database?

1062

What are the steps you will take to improve the performance of a poor performing query?

957

What are subqueries in sql server?

1096

What is a collation in ms sql server?

1056

Write a SQL queries on Self Join and Inner Join.

1027