Second Min value in sql server

Question

1.00/5 (1 vote)

See more:

I have 10 records in my table ............
now I want to find the second minimum value from the Fess column............
how to get it

Posted 15-Oct-13 19:41pm

Ravinder Soran

Add a Solution

5 solutions

Solution 5

Simple one

SQL

SELECT TOP 1 Fees FROM
(
    select top 2 * from table order by Fees ASC
) AS Table ORDER BY Fees DESC

Posted 17-Oct-13 22:51pm

Amol_B

Comments

Ravinder Soran 25-Oct-13 0:39am

High level commands,,,,,,,,,but thanks bro

Amol_B 25-Oct-13 0:50am

Cheers! Just want to demonstrate a way without using aggregate function

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Thanks7872 · Accepted Answer · 2013-10-15T19:50:00

Solution 1

SQL

select min(your_field) from your_table where your_field NOT IN (select distinct TOP 1 your_field from your_table ORDER BY your_field DESC)

Regards...

Posted 15-Oct-13 19:50pm

Thanks7872

Updated 15-Oct-13 19:51pm

v2

Comments

Rakshith Kumar 16-Oct-13 2:29am

perfect :)

Ravinder Soran 25-Oct-13 0:38am

Thanks Bro...

Thanks7872 25-Oct-13 0:39am

You are welcome. :-)

VeeraAnnapureddy · Accepted Answer · 2013-10-15T20:08:00

Solution 2

Select MIN(Sal) From TableName
Where Sal > (Select MIN(sal) From TableName)

Posted 15-Oct-13 20:08pm

VeeraAnnapureddy

Comments

Ravinder Soran 25-Oct-13 0:40am

This is t#he best and simplest answer ....thanks

DDR-4 · Accepted Answer · 2013-10-16T00:41:00

Solution 3

SELECT MIN(CustID) AS [2ndMin]
FROM Customer
WHERE (CustID >(SELECT MIN(CustID) FROM Customer))

Posted 16-Oct-13 0:41am

DDR-4

Dipesh Wadhwa · Accepted Answer · 2013-10-16T20:22:00

Solution 4

SQL

select top 1 ColumnName from TableName where ColumnName not in (select top 1 ColumnName from TableName order by ColumnName asc)

Example:

SQL

select top 1 id from std where id not in (select top 1 id from std order by id asc )

Posted 16-Oct-13 20:22pm

Dipesh Wadhwa