Select * from table1 where salary = (select max(salary) from table1)

one table has four field id,name,design,salary. i have to
find maximum salary .

Question Posted / prashant

Answer Posted / prashant

Select * from table1 where salary = (select max(salary)
from table1)

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Mention the different types of triggers?

1118

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2485

What is normalization 1nf 2nf 3nf?

1060

Mention the 3 ways to get a count of the number of records in a table.

978

How do I setup a sql server database?

1077

What is the difference between value type and reference type?

922

Which are the third-party tools used in sql server and why would you use them?

911

What is purpose of normalization?

950

What is the default sql server instance name?

1036

Explain the cursor lock types?

1058

How to achieve Paging of records in SQL SERVER?

1102

How can a database be repaired?

990

What is difference between joins and subqueries?

1120

How to locate and take substrings with charindex() and substring() functions?

1016

What is database replication?

1144