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

Explain the difference between cross join and full outer join?

672


How to create view in stored procedure sql server?

688


What are the advantages to use stored procedures?

780


how will add additional conditions in sql?

737


What is the difference between char, varchar and nvarchar?

753






Which are the third-party tools used in sql server and why would you use them?

659


What are the advantages dts has over bcp?

735


Is it possible to call a stored procedure within a stored procedure?

723


Tell me what is the order in which the sql query is executed?

703


Explain the properties of a relational table?

752


What happens when the SQL Azure database reaches Max Size?

104


What is the largest component inside a field?

745


What is auditing in sql server?

685


What is the boxing and unboxing concept in .net?

708


When would you use a before or after trigger?

660