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 are the core components of SSRS?

104


What the class forname () does?

709


What is single-user mode?

693


What is key attribute?

699


Does a specific recovery model need to be used for a replicated database? : sql server replication

709






Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1477


What is difference between equi join and inner join?

649


what types of replication are supported in sql server? : Sql server database administration

656


What are the difficulties faced in cube development? : sql server analysis services, ssas

797


What do you mean by the term 'normalization'?

857


How to create database with physical files specified in ms sql server?

722


What is a data collection table?

723


what happens on checkpoint? : Sql server database administration

696


What is a rownum?

674


What is policy based management (pbm)? : sql server database administration

738