billyleo
asked on
selecting the 2nd highest record?
I need to get the 2nd latest value of my OrderId field.
The code I am using is attached.
Could you pleade tell me why this is a syntax error?
The code I am using is attached.
Could you pleade tell me why this is a syntax error?
select top 1 OrderID from (select top 2 OrderID from
T_orderheader order by OrderID desc)
order by OrderID asc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You may use following query instead :
SELECT MAX(OrderID)
FROM T_orderheader
WHERE OrderID NOT IN
(SELECT MAX(OrderID)
FROM T_orderheader)
SELECT MAX(OrderID)
FROM T_orderheader
WHERE OrderID NOT IN
(SELECT MAX(OrderID)
FROM T_orderheader)
ASKER
Cool, Thx!
SELECT TOP 1 *
FROM (SELECT TOP 2*
FROM tablename
ORDER BY columnname DESC)e1
ORDER BY Sal