Jump to content
  • 0

Finding second lowest number using SQL


pgjacob
 Share

Question

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

 

Link to comment
Share on other sites

1 answer 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.

Guest
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.

Loading...
 Share

×
×
  • Create New...