one table has four field id,name,design,salary. i have to
find maximum salary .
Answer Posted / prashant
Select * from table1 where salary = (select max(salary)
from table1)
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
what are the core components of SSRS?
What the class forname () does?
What is single-user mode?
What is key attribute?
Does a specific recovery model need to be used for a replicated database? : sql server replication
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is difference between equi join and inner join?
what types of replication are supported in sql server? : Sql server database administration
What are the difficulties faced in cube development? : sql server analysis services, ssas
What do you mean by the term 'normalization'?
How to create database with physical files specified in ms sql server?
What is a data collection table?
what happens on checkpoint? : Sql server database administration
What is a rownum?
What is policy based management (pbm)? : sql server database administration