Jump to content
  • 0

Finding second lowest number using SQL



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.




Link to comment
Share on other sites

2 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...