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 sho…