Is it possible to use LIMIT x with the WHERE clause? If so, how?
I'm trying to do this:
select * from myVIew LIMIT 10 where type=3;
But i get the following error:
ERROR: syntax error at or near "where"
LINE 2: where type=3;
^
********** Error **********
ERROR: syntax error at or near "where"
SQL state: 42601
Character: 44
select * from myVIew where type=3 LIMIT 10;
Limit should be after where clause.
Syntax :
SELECT column_name(s)
FROM table_name
[WHERE]
LIMIT number;
Yes, have you tried this?
select * from myVIew where type=3 LIMIT 10;
Look here for further reference. LIMIT is after WHERE and ORDER BY clauses, which makes total sense if you stop and think about it: first you have to define your base result set (filters and orders), then you limit/page it.
select * from myVIew where type=3 LIMIT 10;
