Click here to Skip to main content
15,499,958 members
Home / Discussions / Database
   

Database

 
AnswerRe: Triggers Pin
Kornfeld Eliyahu Peter11-Feb-15 20:37
professionalKornfeld Eliyahu Peter11-Feb-15 20:37 
GeneralRe: Triggers Pin
John C Rayan12-Feb-15 4:32
professionalJohn C Rayan12-Feb-15 4:32 
QuestionRANKING IN VB.NET MYSQL Pin
KipkoechE10-Feb-15 23:27
MemberKipkoechE10-Feb-15 23:27 
SuggestionRe: RANKING IN VB.NET MYSQL Pin
Richard MacCutchan11-Feb-15 1:06
mveRichard MacCutchan11-Feb-15 1:06 
GeneralRe: RANKING IN VB.NET MYSQL Pin
KipkoechE11-Feb-15 2:32
MemberKipkoechE11-Feb-15 2:32 
GeneralRe: RANKING IN VB.NET MYSQL Pin
Richard MacCutchan11-Feb-15 2:36
mveRichard MacCutchan11-Feb-15 2:36 
GeneralRe: RANKING IN VB.NET MYSQL Pin
KipkoechE11-Feb-15 2:41
MemberKipkoechE11-Feb-15 2:41 
AnswerRe: RANKING IN VB.NET MYSQL Pin
GuyThiebaut11-Feb-15 3:11
professionalGuyThiebaut11-Feb-15 3:11 
A bit of google fu[^]gave me this:

SQL
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


modified 11-Feb-15 9:01am.

GeneralRe: RANKING IN VB.NET MYSQL Pin
KipkoechE11-Feb-15 3:23
MemberKipkoechE11-Feb-15 3:23 
GeneralRe: RANKING IN VB.NET MYSQL Pin
GuyThiebaut11-Feb-15 3:28
professionalGuyThiebaut11-Feb-15 3:28 
QuestionVB.NET ITEXTSHARP PDF REPORTS Pin
KipkoechE10-Feb-15 7:38
MemberKipkoechE10-Feb-15 7:38 
QuestionMySQL for MFC application Pin
Anu_Bala10-Feb-15 1:14
MemberAnu_Bala10-Feb-15 1:14 
AnswerRe: MySQL for MFC application Pin
Kornfeld Eliyahu Peter10-Feb-15 3:37
professionalKornfeld Eliyahu Peter10-Feb-15 3:37 
Questionvb.net with mysql Pin
KipkoechE8-Feb-15 18:04
MemberKipkoechE8-Feb-15 18:04 
AnswerRe: vb.net with mysql Pin
PIEBALDconsult8-Feb-15 18:33
professionalPIEBALDconsult8-Feb-15 18:33 
GeneralRe: vb.net with mysql Pin
KipkoechE8-Feb-15 19:56
MemberKipkoechE8-Feb-15 19:56 
GeneralRe: vb.net with mysql Pin
PIEBALDconsult9-Feb-15 4:47
professionalPIEBALDconsult9-Feb-15 4:47 
AnswerRe: vb.net with mysql Pin
ZurdoDev9-Feb-15 5:01
professionalZurdoDev9-Feb-15 5:01 
GeneralRe: vb.net with mysql Pin
Jörgen Andersson9-Feb-15 5:09
professionalJörgen Andersson9-Feb-15 5:09 
QuestionRe: vb.net with mysql Pin
Eddy Vluggen9-Feb-15 6:53
professionalEddy Vluggen9-Feb-15 6:53 
QuestionPopulate one table from another Pin
Corporal Agarn6-Feb-15 5:50
professionalCorporal Agarn6-Feb-15 5:50 
QuestionRe: Populate one table from another Pin
Wendelius6-Feb-15 6:23
mveWendelius6-Feb-15 6:23 
AnswerRe: Populate one table from another Pin
Corporal Agarn6-Feb-15 7:49
professionalCorporal Agarn6-Feb-15 7:49 
AnswerRe: Populate one table from another Pin
Jörgen Andersson9-Feb-15 22:29
professionalJörgen Andersson9-Feb-15 22:29 
GeneralRe: Populate one table from another Pin
Corporal Agarn10-Feb-15 1:42
professionalCorporal Agarn10-Feb-15 1:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.