I'm trying to identify in my database which users are using other users' "IDs". MY DB: ID | NAME | CARDNUMBER | SHOPNUMBER 1 JO 1234 73839 2 ANDY 9876 79487 3 KARL 5432 87399 4 MIKE 1234 53637 I…
I wish to achieve something like this from a MYSQL SELECT query I wish to group the results from the select in 500 rows (per batch) and have a column called group (or anything) for the key to the group…
When I run this following select query on the command line in Mysql: SELECT date_sent FROM books; I get this sort of result (eg) | 2024-10-06 | but if I run the same select query from inside python: # Select…
I need to parse JSON using Oracle SQL select. Here is my JSON: {"result":[ { "field_name1":{"display_value":"TEST1","link":"https://test1.com","value":"abcd"}, "field_name2":{"display_value":"","link":"","value":""}, "field_name3":{"display_value":"TEST3","link":"https://test3.com","value":"efgh"}, "field_name4":{"display_value":"TEST4","link":"https://test3.com","value":"ijkl"} } ]} I want to get results as follows: field_name1:abcd field_name3:efgh field_name4:ijkl excluding those that have nulls in the value. How…
I unexpectedly executed the following query in MySQL and got a strange result: SELECT 'a' 'b' 'c' FROM dual; The result shows 'a' as the column name and 'abc' as the value. I am puzzled by this behavior. What is…
I'm able to create the table using CTE with select statement like below but it's not behaving like I want. with sorting(item_code, index) as ( select (10001, 1), (10002, 2) ) select * from sorting Table result : item_code|index |…
I want to loop through columns ['A', 'B', 'C'] and pass the column names to a select statement in SQL, such as SELECT * FROM table_name WHERE table_name.`A` IS NULL Thus each select statement would yield a result set based…
I am Working on project, where I am using two queries to get the result i wanted to process. Query 1 SELECT MID FROM PMS.MACHINE WHERE STATUS=1 AND MID !=0; Query 2 SELECT MID,COUNT(STATUS) AS QUEUE FROM PMS.QUEUE WHERE STATUS=0…
I have a result set of parent categories and subcategories. I want to exclude all parent categories if a subcategory exists in the results. What I would do is using a NOT IN in the query, but that requires a…
I have two HTML tags. Depending on the selected in the first one, I need to display only 1 out of 5 secondary tags and hide the other 4 with display :none. My Javascript listens for the change event on…