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

Answer Posted / sujit

select max(sal) from <tablename>
if this answer not correct plz give me commets on the answer

Is This Answer Correct ?    13 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the 2 types of classifications of constraints in the sql server?

577


I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

593


What are the advantages of using third-party tools?

542


What are click through reports?

99


How to rename databases in ms sql server?

616






What is mean by candidate key?

530


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1461


How many triggers are possible per table?

616


What do you understand by triggers and mention the different types of it?

479


What is the difference between system objects and user objects?

699


What are the new features in SQL Server 2005 when compared to SQL Server 2000?

616


Can You Use Data Mining Models In Ssrs?

97


Can we write ddl in trigger?

490


Explain user defined views?

566


Difference between aggregate functions of sql?

645