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

Answer Posted / guest

select * from tab where max(salary)

Is This Answer Correct ?    4 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain concepts of analysis services?

503


Indexes are updated automatically is the full-text index also updated automatically?

618


What is tablix?

115


Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

629


What is plan freezing?

575






Can a unique index be created on a column, which contains null?

515


Is null vs coalesce?

497


What is sqlcmd?

549


What is the name of reporting services config file and what’s it’s used for?

107


If we delete pack Spec what will be the status of pack Body ?

961


What are the difference between clustered and a non-clustered index?

580


Explain encryption of entire databases without the need for application changes in sql server 2008?

555


Write a query to find 5th highest amount paid from the customer table.

523


What is collation sensitivity?

543


How to get all stored procedures in sql server?

501