Question : Question is most probably stupid but I am stuck on this and cant think anymore(Pissed Off). I have […]
Tag: select
Update rows in a table with an index column starting from 0 with consecutive numbers
Question : I have a few tables in a Oracle db with some “rule”: The INDEX_COLUMN must start from 0 […]
Is there a table size above which SELECT performance degrades significantly?
Question : In MySQL, does SELECT performance degrade significantly after a certain table size? I have a table with about […]
How to use GROUP_CONCAT for a column and COUNT(*)?
Question : I get the ids of a query by GROUP_CONCAT. SELECT GROUP_CONCAT(ArticleID) FROM TagMap WHERE Tag IN(…) How can […]
SQL insert into … values (…, select(…))
Question : I am trying to insert 25 users, user1…25 into Members with the same GR_ID = 2 with command: […]
mySQL changing output unit of ST_Distance function
Question : I’m trying to get a result in nautical miles between two lon/lat saved in a point data type […]
Select query – group by and sub group by
Question : CREATE TABLE [dbo].[temptable] ( [Id] INT NOT NULL PRIMARY KEY IDENTITY, [uid] INT NOT NULL, [pid] INT NOT […]
How to split a SUM column based on another BIT column? [duplicate]
Question : This question already has answers here: mysql: counting number of tickets which are open per day basis (2 […]
Selecting rows with condition on two columns together
Question : i have table with columns Number and VAT How can i select all rows without row which is […]
Speeding up a simple select query on Mariadb
Question : I have a 100k rows table with the following structure: +———-+——————+——+—–+———+—————-+ | Field | Type | Null | […]