i forgot order by in da last post SQL Server: Select MIN(Salery) from (SE

how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?

Question Posted / prasoon madnawat

11 Answers
15611 Views
GeoTechnology, Wipro, I also Faced
E-Mail Answers

Answer Posted / prasoon madnawat

i forgot order by in da last post
SQL Server:
Select MIN(Salery) from (SELECT TOP 2 * from EMPLOYEE order
by Salery DESC)

Oracle:
Select MIN(Salery) from (SELECT * from EMPLOYEE where ROWNUM
<3 order by Salery DESC)

MySQL
Select MIN(Salery) from (SELECT * from EMPLOYEE order by
Salery DESC LIMIT 2)

likewise for 2nd minimum salery.

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain about .net garbage collector?

936

server.transfer limitation ?

2212

Explain is development of a mobile web application with asp.net is very easy? : Microsoft dot net mobile

929

Explain about microsoft visual studio?

947

Can you Explain element .net mobile with example? : Microsoft dot net mobile

927

difference between data reader and dataset

2202

difference between Response.write,server.transfer and also which one is used when ?

1898

Explain about the base class library provided by microsoft.net?

1044

Explain hard disk and what is its purpose? : Dot net architecture

928

question related to table havi colspan and row span

2245

I am working with asp.net 2005 and Crystal report 10. I have an image field on my dataset to show on Crystal report.And the image is shows dynamically from database in image field of CR. The image field is showing well on my Crystal report on its first page with all other data but when i click to open second page of CR,it does not show any data on that.I found that this is because of adding the image field on crystal report. Because when i remove the image field from the CR then it will run both the pages of CR. I am using the Page Load event to bind CR data with Database. And i have already check with the Init event to bind CR , but it still not shows the data on second page when i use image field on that. Please give solution for that.....

1864

Xmlserializer is throwing a generic "there was an error reflecting myclass" error. How do I find out what the problem is?

944

Explain the difference between state server and sqlserver : Dot net architecture

868

Whate are resource files? How are they used in .net?

891

How does .net mobile work? : Microsoft dot net mobile

931