Please have a look at the following data example: In this table, I have multiple columns. There is no PRIMARY KEY, as per the image I attached, there are a few duplicates in STK_CODE. Depending on the (min) column, I want to remove duplicate rows. According to the image, one stk_code has three different rows.…
Tag: subquery
Categorizing a sub-expression within an expression
Let’s say I have the following select_expr: Ignoring the fact that this query doesn’t make sense, I’m curious how the second select_expr would be categorized: I suppose all three items can be called ‘operands’ and the second two can be called ‘sub-selects’, but is the…
MySQL – #1064 – Something is wrong in your syntax ‘LIMIT 0, 25’
Server: MariaDB, version 10.4.17 Query: Error in phpMyAdmin: Error in MySQL Workbench: All right so MariaDB decided to modify my query throw error that shouldn’t be thrown Let’s find out what is wrong with select something from (select 1, 2 as something) limit 123: I restarted the server and this …
Oracle SQL: select from a set of orders only those that contain certain types
I want to select from a set of orders only those that are marked with certain types. Example: Let’s assume I have a table X. In my case I want to select only those orders that contain both A and B: My work so far: However, I don’t like this solution. Is there a better approach? Answer Use an analy…
Return only recipes that contains all ingredients Sql
I have these 3 tables: Drinks drink_id name Ingredients ingredient_id name Opskrifter drink_id ingredient_id quantity Drinks and Ingredients are cross-referenced in opskrifter. I want to return all recipes from opskrifter that have ingredients from another table called Stock name So to make a gin and tonic, I…
How to display the total count of the last row by filestatus?
I have to display the total count of the last row by filestatus. tbl_bankdata tbl_fileStatus I have two tables tbl_bankdata and tbl_fileStatus. I am sending bank_id in the tbl_fileStatus as a f_bank_id. Now I have to show the last f_bankid count. For example, I have to fetch the count where f_filestatus=1. so…
Pgsql find similar records in database
I have a table that has the layout of this sensor_id time value 1 2020-12-22 09:00:00 20.5 1 2020-12-22 10:00:00 21.5 1 2020-12-22 11:00:00 22.5 1 2020-12-22 12:00:00 23.5 2 2020-12-22 09:00:00 …
Query items from a history table
I have a “library” history table (Excel like) to see where a book was or is. id date book action client 1 2020-12-01 1 toClient 1 2 2020-12-02 1 returned 1 3 2020-12-03 1 toClient 2 4 2020-12-04 2 toClient 2 5 2020-12-05 3 toClient 1 6 2020-12-06 3 returned 1 7 2020-12-07 2 returned 2 8 2020-12-08…
MySQL: Select penult values
There are 2 tables: table1: id |phone| order| —|—–|——| 1 | 122 | 6 | 2 | 122 | 4 | 3 | 122 | 3 | 4 | 123 | 6 | 5 | 123 | 5 | 6 | 123 | 3 | 7 | 124 | 6 |…
SQL SELECT showing records only if the number of records is greater than N
I have a table defined like this (MySQL 5.1): Sample dataset: I need to show records matching a certain criteria (lets suppose lastname = ‘Santucci’ ) only if the number of records is greater than a certain defined limit (lets say 2). I tried in various way without success the most promising form …