Click here to Skip to main content
15,867,453 members
Home / Discussions / Database
   

Database

 
QuestionRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 4:33
professionalGuyThiebaut12-Feb-15 4:33 
GeneralRe: MYSQL RANKING IN A VIEW Pin
Richard Deeming12-Feb-15 4:34
mveRichard Deeming12-Feb-15 4:34 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 4:53
KipkoechE12-Feb-15 4:53 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:03
KipkoechE12-Feb-15 5:03 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 5:18
professionalGuyThiebaut12-Feb-15 5:18 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:23
KipkoechE12-Feb-15 5:23 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 5:28
professionalGuyThiebaut12-Feb-15 5:28 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 6:05
KipkoechE12-Feb-15 6: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 21:52
ahmed_sa11-Feb-15 21:52 
AnswerRe: Add allowance to employee table is wrong or true according to my case Pin
David Mujica12-Feb-15 3:49
David Mujica12-Feb-15 3:49 
AnswerRe: Add allowance to employee table is wrong or true according to my case Pin
Mycroft Holmes12-Feb-15 12:01
professionalMycroft Holmes12-Feb-15 12:01 
QuestionTriggers Pin
Member 1116162511-Feb-15 19:19
Member 1116162511-Feb-15 19:19 
AnswerRe: Triggers Pin
Kornfeld Eliyahu Peter11-Feb-15 19:37
professionalKornfeld Eliyahu Peter11-Feb-15 19:37 
GeneralRe: Triggers Pin
John C Rayan12-Feb-15 3:32
professionalJohn C Rayan12-Feb-15 3:32 
QuestionRANKING IN VB.NET MYSQL Pin
KipkoechE10-Feb-15 22:27
KipkoechE10-Feb-15 22:27 
SuggestionRe: RANKING IN VB.NET MYSQL Pin
Richard MacCutchan11-Feb-15 0:06
mveRichard MacCutchan11-Feb-15 0:06 
GeneralRe: RANKING IN VB.NET MYSQL Pin
KipkoechE11-Feb-15 1:32
KipkoechE11-Feb-15 1:32 
GeneralRe: RANKING IN VB.NET MYSQL Pin
Richard MacCutchan11-Feb-15 1:36
mveRichard MacCutchan11-Feb-15 1:36 
GeneralRe: RANKING IN VB.NET MYSQL Pin
KipkoechE11-Feb-15 1:41
KipkoechE11-Feb-15 1:41 
AnswerRe: RANKING IN VB.NET MYSQL Pin
GuyThiebaut11-Feb-15 2:11
professionalGuyThiebaut11-Feb-15 2:11 
GeneralRe: RANKING IN VB.NET MYSQL Pin
KipkoechE11-Feb-15 2:23
KipkoechE11-Feb-15 2:23 
GeneralRe: RANKING IN VB.NET MYSQL Pin
GuyThiebaut11-Feb-15 2:28
professionalGuyThiebaut11-Feb-15 2:28 
QuestionVB.NET ITEXTSHARP PDF REPORTS Pin
KipkoechE10-Feb-15 6:38
KipkoechE10-Feb-15 6:38 
QuestionMySQL for MFC application Pin
Anu_Bala10-Feb-15 0:14
Anu_Bala10-Feb-15 0:14 
AnswerRe: MySQL for MFC application Pin
Kornfeld Eliyahu Peter10-Feb-15 2:37
professionalKornfeld Eliyahu Peter10-Feb-15 2: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.