T-SQL Query to Find the Second Highest Column Value in a Table

re: T-SQL Query to Find the Second Highest Column Value in a Table

Pradeep — Wed, 24 Feb 2010 03:32:59 GMT

Thanks Raj

I was looking for such answer from long time.

Its simple and amazing.

re: T-SQL Query to Find the Second Highest Column Value in a Table

Sharath — Thu, 18 Feb 2010 16:46:19 GMT

Can you please explain about Dence Rank function please..

re: T-SQL Query to Find the Second Highest Column Value in a Table

M. — Fri, 29 Jan 2010 15:53:54 GMT

-get All with the subquery in one statement :

the productId and the product name

the number of the customers whose buy this product

the number of the Employess whose sale this product

the max price that the product was sold with it

the max quntity that the product was sold in one order

the category name

the supplier name

re: T-SQL Query to Find the Second Highest Column Value in a Table

Mostafa Adam — Fri, 29 Jan 2010 15:53:10 GMT

-get All with the subquery in one statment

1-the productId and the product name

2-the number of the customers whose buy this product

3-the number of the Employess whose sale this product

4-the max price that the product was sold with it

5-the max quntity that the product was sold in one order

6-the category name

7-the supplier name

re: T-SQL Query to Find the Second Highest Column Value in a Table

Murugaveni.K — Fri, 29 Jan 2010 06:36:38 GMT

Please send how to code to find the highest record from a field while the number is added with any string.

for example "BIS001,BIS002,BIS009,BIS010,BIS003"...i need ans hear is BIS010

re: T-SQL Query to Find the Second Highest Column Value in a Table

Murugaveni.K — Fri, 29 Jan 2010 06:36:35 GMT

Please send how to code to find the highest record from a field while the number is added with any string.

for example "BIS001,BIS002,BIS009,BIS010,BIS003"...i need ans hear is BIS010

re: T-SQL Query to Find the Second Highest Column Value in a Table

Sudhakar Nune — Tue, 22 Dec 2009 12:54:41 GMT

To get second highest salory from tbale in SQL developer use below qry ::

select * from (select distinct sal,rownum rn from Table_nam order by sal desc ) where rn =2

re: T-SQL Query to Find the Second Highest Column Value in a Table

Harnish Prajapati — Wed, 16 Sep 2009 04:25:09 GMT

select top 1 Ename,salary from (select top 2 Ename,salary from tblsalary order by salary desc) a

order by salary asc

re: T-SQL Query to Find the Second Highest Column Value in a Table

Harnish Prajapati — Wed, 16 Sep 2009 04:22:52 GMT

select top 1 Ename,salary from (select top 2 Ename,salary from tblsalary order by salary desc) a

order by salary asc

re: T-SQL Query to Find the Second Highest Column Value in a Table

Karthik — Sat, 12 Sep 2009 06:20:10 GMT

select a.salespersonid,salesquota from Sales.SalesPerson A where 3=(select count(distinct

B.salesquota) from Sales.SalesPerson B where B.salesquota>=A.salesquota)

re: T-SQL Query to Find the Second Highest Column Value in a Table

jigneshthumar@yahoo.com — Wed, 02 Sep 2009 18:05:41 GMT

SELECT *

FROM Employee

WHERE Sal = (

SELECT Sal

FROM Employee

GROUP BY Sal D

LIMIT 1 , 1 )

re: T-SQL Query to Find the Second Highest Column Value in a Table

Ian Fila — Tue, 14 Jul 2009 19:25:00 GMT

How would you do this with two fields ?

I have a bunch of records, uniqueid.

The higher the uniqueid the newer the record.

I want to extract all the records with the highest uniqueid.

eg.

abc,123

abc,124

abc,125

I want to extract only abc,125.

Thanks

re: T-SQL Query to Find the Second Highest Column Value in a Table

IanSmith — Thu, 02 Jul 2009 23:21:27 GMT

Two issues:

If I have

1000

2000

3000

4000

5000

1) By my interpretation, the third highest salary is that salery earned by the third highest paid employee. That would be 4000, not 3000. All these efforts to eliminate ties don't belong here. Nor does Dense Rank.

2) If you ask what is the 7th highest salary in this list, many of these techniques will fail.

re: T-SQL Query to Find the Second Highest Column Value in a Table

SPK — Thu, 02 Jul 2009 07:57:05 GMT

You can accomplish this using the RANK function as well. The query is given below:

SELECT * FROM

(SELECT salary, RANK () OVER(ORDER BY salary DESC) AS rank FROM emp GROUP BY salary) AS e

WHERE e.rank = 2

NOTE: You can just change the value of the number (1,2,3 etc) to get the first, sceond, third..highest column value.

re: T-SQL Query to Find the Second Highest Column Value in a Table

SPK — Thu, 02 Jul 2009 07:55:51 GMT

You can accomplish this using the RANK function as well. The query is given below:

SELECT * FROM

(SELECT salary, RANK () OVER(ORDER BY salary DESC) AS rank FROM emp GROUP BY salary) AS e

WHERE e.rank = 2

NOTE: You can just change the value of the number (1,2,3 etc) to get the first, sceond, third..highest column value.