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

Answer Posted / soni

SELECT MAX(columnName1)
FROM Employee

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are data driven subscriptions?

95


What is the federation in sql azure?

91


How do I create a stored procedure in dbml?

687


What is TDS(Tabular Data Stream) Gateway?

115


Describe how to use the linked server?

807






code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1968


How to list all triggers in the database with sys.triggers in ms sql server?

749


What is a rollup clause?

715


Do you know the cursor types?

837


What is a non-clustered index?

716


How do we know if any query is retrieving a large amount of data or very little data?

730


What are the different types of sub-queries?

765


you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

740


What are the different types of data sources in ssrs?

165


How to generate random numbers with the rand() function in ms sql server?

758