Question : I originally posted this question on stackoverflow, but then remembered there’s a stackexchange specifically for databases! I’ve got […]
Tag: limits
UPDATE Only one row (using update and join)
Question : I’m trying to get a fast, simple sql query to update only one row at a time while […]
Predicting the primary keys exhaustion in MySQL based on rate of insertion
Question : We are running out of primary keys for our table in production. We do not want that to […]
COUNT(*) gives more than 1 with LIMIT 1?
Question : I’m trying to count old records. Why does Postgres give a result of 1160, even though I set […]
MySQL limits on huge number return zero rows
Question : I have table about 1,000,000 rows. this query work well: SELECT * FROM `articles` WHERE `articles`.`hash` NOT IN […]
How does TOPN influence a query with group by?
Question : I have a query that looks like the following: Select t1.field1, t2.field2, sum(t1.field3) From t1 inner join t2 […]
Limiting the number of records from nested INNER JOIN table
Question : The context is as follows: We have 3 tables: We’ll call them A,B and C. A has a […]
MySQL apply LIMIT and OFFSET to a selected table, rather than to the result set
Question : I have 3 tables as below. mysql> describe IDN_CONFIG_RESOURCE; +—————+————–+——+—–+——————-+——-+ | Field | Type | Null | Key […]
mySQL Query with a LIMIT on a row value
Question : I am trying to replace a lot of queries like this with a single query. SELECT * FROM […]
Display Top X results for each unique value
Question : I am trying to figure out how I can output any machine that has had the latest 3 […]