Re: Pagination Group By - limit
> SELECT * FROM table_name WHERE level = '3' GROUP BY state
That will return one arbitrary value row per state with level=3. Probably not what you had in mind. read about only_full_group_by in the manual.
> ORDER BY state ASC limit $ start, $ quantity
Lose the space between $ and the following name. (The script doesn't set these values.)
Subject
Written By
Posted
Re: Pagination Group By - limit
January 25, 2018 04:15PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.