순위내기..등수뽑아오기
페이지 정보
작성자 최고관리자 작성일 21-02-09 11:55 조회 3,555 댓글 0본문
select * from (
select a.id, u.name, (select count(*)+1 as myRank from rankeytable p join MemBer m on m.id=p.id and m.outyn='N' where
CONCAT(LPAD(p.maxAscore ,10,'0'),LPAD(p.maxBscore ,10,'0'),(10000000000 - unix_timestamp(p.regdate))) >
CONCAT(LPAD(a.maxAscore ,10,'0'),LPAD(a.maxBscore ,10,'0'),(10000000000 - unix_timestamp(a.regdate))) ) as rank
from rankeytable a join MemBer u on u.id=a.id and outyn='N' where a.ymddate='2014-06-10') as m
where m.rank >0 order by m.rank limit 0,10
순위 앞뒤 몇명이면...
where m.rank between A and B order by m.rank limit 0,10
----------------------------------------------------------------------
특정한 등수 이후의 10명...
select no, CONCAT(date_format(regdate,'%Y%m%d'),10-priceRk) as orderbypoint from tablename
where CONCAT(date_format(regdate,'%Y%m%d'),10-priceRk) < CONCAT('$row[ymddate]',10-$row[priceRk])
order by orderbypoint desc
limit 0,10
select a.id, u.name, (select count(*)+1 as myRank from rankeytable p join MemBer m on m.id=p.id and m.outyn='N' where
CONCAT(LPAD(p.maxAscore ,10,'0'),LPAD(p.maxBscore ,10,'0'),(10000000000 - unix_timestamp(p.regdate))) >
CONCAT(LPAD(a.maxAscore ,10,'0'),LPAD(a.maxBscore ,10,'0'),(10000000000 - unix_timestamp(a.regdate))) ) as rank
from rankeytable a join MemBer u on u.id=a.id and outyn='N' where a.ymddate='2014-06-10') as m
where m.rank >0 order by m.rank limit 0,10
순위 앞뒤 몇명이면...
where m.rank between A and B order by m.rank limit 0,10
----------------------------------------------------------------------
특정한 등수 이후의 10명...
select no, CONCAT(date_format(regdate,'%Y%m%d'),10-priceRk) as orderbypoint from tablename
where CONCAT(date_format(regdate,'%Y%m%d'),10-priceRk) < CONCAT('$row[ymddate]',10-$row[priceRk])
order by orderbypoint desc
limit 0,10
댓글목록 0
등록된 댓글이 없습니다.