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

Answer Posted / prashant

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

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between createstatement and preparedstatement?

484


What are the reporting services components?

92


Explain what is log shipping?

564


Which are the important points to note when multilanguage data is stored in a table?

509


What is the command dbcc checkdb used for?

530






What are the types of processing and explain each? : sql server analysis services, ssas

732


How to check table values in sql server?

526


Explain the use of containers in ssis and also their types?

520


What are the general features of sql server management studio? : sql server management studio

585


Can sql servers linked to other servers?

539


What are distinctive joins find as a part of sql?

549


Different types of keys in SQL?

616


What is rolap and its advantage? : sql server analysis services, ssas

636


How to create function with parameter in sql server?

548


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

1550