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

How to get the definition of a view out of the sql server?

495


What the different topologies in which replication can be configured?

553


Write a sql query to get zero records from a table having n number of records?

705


What is the difference between left and right outer join?

537


What are transactions and its controls?

607






How to write an inner join with the where clause in ms sql server?

545


Explain what is lock escalation?

569


What information is maintained within the msdb database?

534


How to list all schemas in a database?

568


List all types of constraints in sql server?

509


Can you explain different types of joins?

539


What Is Rdbms?

664


What are user defined functions in ms sql server?

500


What is clustered index

563


What is de-normalization in sql database administration? Give examples?

528