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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / prashant

Select * from table1 where salary = (select max(salary)
from table1)

Is This Answer Correct ?    8 Yes 0 No

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

Answer / ashish

hi,, it work


select * from table where salary =(select max(salary) from
table) .......this returns whole record of that salary,,,,
an if u want just that maximum salary than



select max(salary) from table

Is This Answer Correct ?    6 Yes 0 No

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

Answer / elumalai.k

select max(salary) from tablename

Is This Answer Correct ?    4 Yes 0 No

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

Answer / soni

SELECT MAX(columnName1)
FROM Employee

Is This Answer Correct ?    3 Yes 1 No

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

Answer / guest

select * from tab where max(salary)

Is This Answer Correct ?    4 Yes 8 No

Post New Answer

More SQL Server Interview Questions

What is buffer cash in sql server?

0 Answers  


What is normalization?

9 Answers  


Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,


explain different types of cursors? : Sql server database administration

0 Answers  


What is a transact-sql statement batch in ms sql server?

0 Answers  






What is spid in sql server profiler?

0 Answers  


What is data compression? : sql server database administration

0 Answers  


Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,


Is truncate a dml command?

0 Answers  


what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,


How can you see what type of locks used?

1 Answers  


What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,


Categories