what does adding ranked to a mysql query do?

Question

What does adding ranked to a mysql query do?

I'm trying code from this post

SELECT * FROM ( SELECT @row := @row +1 AS rownum, [column name] FROM ( SELECT @row :=0) r, [table name] ) ranked WHERE rownum % [n] = 1

...you're going to have to be a bit more specific here, i feel — Jason, Jul 29 '09 at 20:09

score 5 · Accepted Answer · answered Jul 29 '09 at 20:18

5

"ranked" is an alias that you're giving to your sub-select. You're just omitting the "AS" keyword, which is allowed in MySQL.

Example: SELECT name from MyTable AS table1

answered Jul 29 '09 at 20:18

Alex Weinstein

score 2 · Answer 2 · answered Jul 29 '09 at 20:12

2

Nothing, apparently, as "ranked" isn't a MySQL keyword that I can find. Did you possibly mean "ordered by"?

answered Jul 29 '09 at 20:12

markh

2 Answers2