adspace


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


Please Help Members By Posting Answers For Below Questions

Can sql servers link to other servers like oracle?

915


What is the difference between for xml raw and for xml auto?

1113


How to connect php with different port numbers?

1185


How can you append an identity column to a temporary table?

1069


How can we solve concurrency problems?

1121


Equi join and non equi join is possible with sql server?

1133


How can I check that whether automatic statistic update is enabled or not?

1111


Can we shrink data file in sql server?

1125


Why and when do stored procedure recompile?

1056


How to provide default values to function parameters?

1256


Where can you add custom error messages to sql server?

1208


If any stored procedure is encrypted, then can we see its definition in activity monitor?

1068


How do I find query history in sql server?

1022


How to convert character strings into numeric values?

1189


What is subquery? Explain the properties of a subquery?

1058