|
||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread |
| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
|
||||||
|
|
|
LinkBack | Thread Tools | Search this Thread |
01-22-2008, 07:11 PM
|
|||
|
|||
ANY answer.
Re: how do find the 15th highest value in the coloum without using subquery?
Hi,
Here is an answer for MySQL: mysql> select id from top15 order by id desc limit 1 offset 14; The offset of the initial row is 0, thus the value of 14 (count(0..14)=15). Limit 1 tells we want just one row of the result set. Hope this helps, Dimitar     
|
|
| Thread Tools | Search this Thread |
|
|
