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

Answer Posted / elumalai.k

select max(salary) from tablename

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How you trouble shoot when any job fails

1675


what are the Prerequisites for Replication?

10875


you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

727


How many joins in sql server?

687


Define outer join in sql server joins?

677






Differentiate between a local and a global temporary table?

707


Which is the best place or learning center for MS SQL?????In Bangladesh?????

1755


Explain for xml explicit mode?

734


What is row_number function?

738


how many no of arguments can be passed in procedures and functions

5055


Explain few of the new features of sql server 2008 management studio

685


What is a join in sql? What are the types of joins?

689


What do we need queues in sql service broker?

692


Can we use custom code in ssrs?

778


What do you know about system database? : SQL Server Architecture

671