Where would the Limit statement go? Postgresql

Question

Short Question, where would the limit clause go in Postgresql? I want to limit the amount of rows to 10, but it is giving me an error when I do;

From this_table x
    join this_table y
    on x.no = y.no


where x.no = '7'
Limit 10
group by x.location
order by x.location

It's giving me a syntax error at or near "where"

(If requested, I could add the select statement.

http://www.postgresql.org/docs/current/static/sql-select.html — a_horse_with_no_name, May 09 '14 at 23:15

score 2 · Accepted Answer · answered May 09 '14 at 22:33

2

limit is the last clause in a select query, so it goes after the order by:

select <whatever>
From this_table x
    join this_table y
    on x.no = y.no
where x.no = '7'
group by x.location
order by x.location
Limit 10;

answered May 09 '14 at 22:33

Gordon Linoff

1 Answers1