can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / divya
select max(sal) from tablename where sal<(select
max(sal)from tablename)
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the default sql server instance name?
What happens if null values are involved in datetime operations?
What is a non-clustered index?
What is the difference between having clause and where clause in sql server?
Explain the Ways to improve the performance of a sql azure database?
Explain about extended stored procedure?
How to check if a table is being used in sql server?
What are various aggregate functions that are available?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
How to verify a login name with sqlcmd tool?
What is index in an assignment?
Does view occupy space?
Can you roll back the ddl statement in a trigger?
What are the approximate numeric data types?
Explain DBCC?