Click here to Skip to main content
15,558,792 members
Home / Discussions / Database
   

Database

 
QuestionRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 5:33
professionalGuyThiebaut12-Feb-15 5:33 
GeneralRe: MYSQL RANKING IN A VIEW Pin
Richard Deeming12-Feb-15 5:34
mveRichard Deeming12-Feb-15 5:34 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:53
KipkoechE12-Feb-15 5:53 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 6:03
KipkoechE12-Feb-15 6:03 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 6:18
professionalGuyThiebaut12-Feb-15 6:18 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 6:23
KipkoechE12-Feb-15 6:23 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 6:28
professionalGuyThiebaut12-Feb-15 6:28 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 7:05
KipkoechE12-Feb-15 7:05 
finally the ranking is on ascending order and need it to be in such a way that the highest marks/value takes position 1:
tried this:
create view View_Positioning as SELECT t1.`SAdmNo`, t1.`YearAdmitted`,t1.`TermAdmitted`,t1.`CLASSAdmitted` ,t1.`StreamAdmitted`,t1.`OutOfMarks`,t1.`ENGLISH`,t1.`KISWAHILI`,t1.`MATHEMATICS`,t1.`SCIENCE`,t1.`SSR`,t1.`Average`,(SELECT COUNT(*) FROM total_termaverage_view WHERE `Average` IS NOT NULL AND`Average` < t1.`Average`) +1 AS Position FROM total_termaverage_view t1 order by Average ASC ;

which gives:
Average position
324 1
345 2
QuestionAdd allowance to employee table is wrong or true according to my case Pin
ahmed_sa11-Feb-15 22:52
ahmed_sa11-Feb-15 22:52 
AnswerRe: Add allowance to employee table is wrong or true according to my case Pin
David Mujica12-Feb-15 4:49
David Mujica12-Feb-15 4:49 
AnswerRe: Add allowance to employee table is wrong or true according to my case Pin
Mycroft Holmes12-Feb-15 13:01
professionalMycroft Holmes12-Feb-15 13:01 
QuestionTriggers Pin
Member 1116162511-Feb-15 20:19
Member 1116162511-Feb-15 20:19 
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
KipkoechE10-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
KipkoechE11-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
KipkoechE11-Feb-15 2:41 
AnswerRe: RANKING IN VB.NET MYSQL Pin
GuyThiebaut11-Feb-15 3:11
professionalGuyThiebaut11-Feb-15 3:11 
GeneralRe: RANKING IN VB.NET MYSQL Pin
KipkoechE11-Feb-15 3:23
KipkoechE11-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
KipkoechE10-Feb-15 7:38 
QuestionMySQL for MFC application Pin
Anu_Bala10-Feb-15 1:14
Anu_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 

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.