Skip to content
Advertisement

Selecting 7th Person (row) and get 7 as result

I want to select the 7th person (Pierre Gasly (for example)) Score list Season F1, so I can return number 7 in my C# application.

Advertisement

Answer

Use a row limiting clause:

This gives you the seventh row in the resultset.

Side notes:

  • table aliases help keeping the query concise and easier to write
  • you should be qualifying all columns that come into play in the query

On the other hand, if you are trying to get the rank of a specific person, then that’s different. You can use rank() instead:

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement