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

What different steps will a sql server developer take to secure sql server?

1041

Explain what are the different index configurations a table can have?

1167

What are xml indexes?

1010

What is faster join or union?

1322

Explain candidate key, alternate key, and composite key?

1062

What is full outer join in sql server joins?

1143

Explain the use of containers in ssis?

1019

What is sub query and its properties?

1027

What are the different types of columns types constraints in the sql server?

1136

Explain the functionalities that views support?

1162

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1069

What is purpose of normalization?

1001

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

972

What is difference between rownum and rowid?

958

What are the basic features of a trigger in ms sql server?

1270