Finding second lowest number using SQL

[pgjacob]

Just wondering if there is a way to find the second lowest number in a view.  I have done the SQL for lowest number:

 

SELECT TOP(1) Drivers_Driver FROM _v_Race_Results_v WHERE Results_RID=[@field:RID] ORDER BY Results_Finish ASC

 

 

I see it's possible by nesting queries using select distinct?  Not sure.  Just need to find the next lowest entry in this list.

 

thanks

 

[MayMusic]

You can try this :

 

SELECT TOP 1 Drivers_Driver FROM 

(SELECT TOP 2 Drivers_Driver FROM  _v_Race_Results_v  WHERE         Results_RID=[@field:RID]    ORDER BY Results_Finish ASC )

AS tt ORDER BY Results_Finish DESC

 

[futurist]

Hi @pgjacob

You can also do something like this:
 

 

 

You can call the second, third, fourth and whichever record