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

Do you know sql server 2008 backup compression?

574


How to link tables in sql server?

483


How to connect a database with sql express.?

580


What is report server project?

106


How are the unique and primary key constraints different?

575






If any stored procedure is encrypted, then can we see its definition in activity monitor?

562


Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

591


Write a sql query to sort on different column name according to the parameters passed in the function?

540


Can you type more than one query in the query editor screen at the same time?

584


What is raiseerror? What is raiseerror?

654


What is meant by referential integrity?

597


What is the report model project?

103


What stored by the master?

558


What is the difference between drop table and truncate table?

497


What is a database table?

537