Interested to Buy Any Domain ? << Click Here >> for more details...
can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 32684 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / elumalai.k
select max(salary)from tablename where salary <(select
max(salary)from tablename)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the truncate command?
when would you go for denormalization? : Sql server database administration
sql database suspect We have a sql database that is showing as suspect. How can we recover?
How to find Duplicate Records In table?
What is a periodical index?
What is lock escalation? : sql server database administration
Where views are stored in sql server?
How network traffic be reduced by using the stored procedure?
What is the difference between for auto and for nested?
How do you troubleshoot errors in a SQL Server Agent Job?
How do you migrate data from mssql server to azure?
What is the command used to recompile the stored procedure at run time?
How does clustered and non clustered index work?
What are the different types of backups avaialabe in sql server 2005?
What is a result set object returned by odbc_exec()?
