one table has four field id,name,design,salary. i have to
find maximum salary .
Answers were Sorted based on User's Feedback
Answer / prashant
Select * from table1 where salary = (select max(salary)
from table1)
Is This Answer Correct ? | 8 Yes | 0 No |
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 |
What is difference between restoration and recovery in SQLServer?
what is a cursor and what is its use?
How to write a script for upate the data in prod , i have 50000 row are there
What is the security principal at the server level that represents your session?
How are the exceptions handled in sql server programming?
What is the query optimization statistics?
What is 5nf in normalization form?
What are diverse clauses that form a part of sql?
Can we call SP inside a query?
5 Answers CA, CarrizalSoft Technologies, Wipro,
Can a table have 2 foreign keys?
How to assign null values to variables or columns?
How do I manually uninstall an instance of sql server 2016?