2
Reply

SQL Query to find second highest value

Bineesh  VP

Bineesh VP

Nov 28 2013 12:17 AM
1k
Sir, I need your help to find the second highest value related to this query.

Here I writing query to find the customerName, ProductName and  ProductPrice.

  select A.customerName,B.productName,B.unitPrice  from tbl_Customer as A
 
inner join tbl_custProductSales on A.customerId=tbl_custProductSales.customerId inner join
 tbl_Product
as B on B.productId=tbl_custProductSales.productId

Like this I want to get the second highest productPrice, customer and productName

My result would be:

customer     product      second_highest_productRate
-----------------------------------------------------


Answers (2)