Databases
StackOverflow2013
Usersdbo
USuser1989497
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USuser1989497
    primarykey
    data
    text
    plurals
    1. This table or related slice is empty.
    1. POSplit a string at the thrid occurance from end in js
      singulars
      1. PTQuestion
    2. POmysql several column ranking per group
      singulars
      1. PTQuestion
    3. PONFC tag and php
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. COthis is my query as for now select k.studid, k.name,k.clevel,k.term,k.subject1, (select count(distinct subject1) from testrank tt join testrank k on k.subject1 <= tt.subject1 )subject1rank, k.subject2, (select count(distinct subject2) from testrank tt join testrank k on k.subject2 <= tt.subject2 )subject2rank from testrank k group by k.studid, k.name,k.clevel this is what have come up with but am not getting the ranking. its just repeating one number in all rows. Kindly assist me on where am going wrong
      singulars
      1. PO
      1. USuser1989497
    2. COGordon I followed you sample query abouve and managed to execute bt the problem am getting is as follows <pre>studid name clevel term eng kisw maths subj1rank subj2rank 987 muy lv01 2 76 31 35 7 24 674 yed lv01 1 49 26 35 7 24 543 jack lv01 1 56 26 75 7 24 453 hei lv01 1 36 66 75 7 24 341 reds lv01 2 87 34 75 7 24 265 mal lv01 2 54 34 54 7 24 253 mark lv01 1 64 45 80 7 24 213 victor lv01 1 56 45 30 7 24 </pre>
      singulars
      1. PO
      1. USuser1989497
    3. COTHIS WHAT I HAD DONE SET @SB1=1; SET @SB2=1; SET @PREV_SUB1=NULL; SET @PREV_SUB2=NULL; create view viewss as SELECT STUDNO,NAME,LEVEL,YEAR,TERM,SUB1,SUB1RANK,SUB2,SUB2RANK FROM ( SELECT *, @SB1:=IF(@PREV_SUB1!=SUB1,@SB1+1,@SB1) AS SUB2RANK,@PREV_SUB1:=SB1 FROM ( SELECT STUDENTNUMBER,fullnames,stream,ACADEMICYEAR,TERMCODE,ACADLEVELCODE,@SB2:=IF(@PREV_SUB2!=ENG,@SUB2+1,@SB2) AS SUB2RANK,@PREV_SUB2:=SB2,SUB1,SUB2 FROM MYTABLE ORDER BY SUB2 DESC )E1 ORDER BY SUB1 DESC )M1
      singulars
      1. POmysql several column ranking per group
      1. USuser1989497
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload