RANKING IN VB.NET MYSQL

[KipkoechE]

I have Records which are supposed to be assigned Position/Be Ranked e.g RegNo Marks Position 1 300 3 301 4 403 5 345 My Problem is How to rank/give position according to marks attained such that the results will be displayed as: RegNo Marks Position 1 300 4 3 301 3 4 403 1 5 345 2 using VB.NET MYSQL

[Lost User]

KipkoechE wrote:

how i will generate the position based on marks

Probably by some calculation and sorting. But if you want some more useful help then please edit your question and explain the problem in proper detail. Also, is this really a Database question or a VB one?

[KipkoechE]

I have Records which are supposed to be assigned Position/Be Ranked e.g RegNo Marks Position 1 300 3 301 4 403 5 345 My Problem is How to rank/give position according to marks attained such that the results will be displayed as: RegNo Marks Position 1 300 4 3 301 3 4 403 1 5 345 2 using VB.NET MYSQL

[Lost User]

You don't need the position field as that depends on the Marks. Just select your data using the ORDER BY clause[^] to sort them.

[KipkoechE]

but that will only sort it...What about the position

[GuyThiebaut]

A bit of google fu[^]gave me this:

SELECT
RegNo,
Marks,
@Position := @Position + 1 AS Position
FROM results , (SELECT @Position:= 0) r
ORDER BY Marks desc;

“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

[KipkoechE]

it worked very well...thanks alot

[GuyThiebaut]

Glad it worked :thumbsup: I used the following google fu[^]

“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

[KipkoechE]

SELECT `RegNo`, Marks, @Position + 1 AS Position FROM results , (SELECT @Position:= 0) r ORDER BY Marks desc; It just needs that simple modification only