In the case more than one highest SALARY, only the Dilip’s answer is co

can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com

Question Posted / arun kumar ks

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

Please Help Members By Posting Answers For Below Questions

Can coalesce return null?

1021

What is buffer cash and log cache in sql server?

1128

What is "scheduled jobs" or "scheduled tasks"?

980

What is dirty read?

1084

What should be the fill factor for indexes created on tables? : sql server database administration

1142

What is nonclustered index with included columns ?

969

What is difference between clustered and non clustered index?

989

Do you know what is user defined datatypes and when you should go for them?

968

What is row_number () and partition by in sql server?

1083

When a primary key constraint is included in a table, what other constraints does this imply?

989

What can be used instead of trigger?

1157

What is the use of set nocount on/off statement?

1097

How do you set a trace flag in sql server?

1041

Explain datetimeoffset data type in sal server 2008?

915

what are the new features introduced in sql server 2000? : Sql server database administration

923