can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / arun kumar ks
In the case more than one highest SALARY, only the Dilip’s
answer is correct.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How do I save a stored procedure in sql server?
How to create an index on an existing table in ms sql server?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
Do you know hot add cpu in sql server 2008?
How to convert a unicode strings to non-unicode strings?
What is SQL Server?
How to delete exactly duplicate records from a table?
How to specify the collation for a character data type in ms sql server?
Can two different columns be merged into single column? Show practically?
Explain what is the difference between union and union all?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
Find first and last day of current month in sql server
How to optimize stored procedures in sql server?
What are user defined functions in ms sql server?