I am trying to place a limit clause on the database query to only show the first 4 results. The current code I am working with is $categories_query = “select c.categories_id, cd.categories_name, …
Tag: sql-limit
SQL select elements where sum of field is less than N
Given that I’ve got a table with the following, very simple content: I would like to select N messages, which sum of verbosity is lower than Y (for testing purposes let’s say it should be 70, then correct results will be messages with id 1,2,3). It’s really important to me, that solution should be database independent (it should work at