Mysql – SQL Query to query 2 tables which has duplicate values
Example Tables: Table: TAB1 Col1 Col2 Col3 Col4 A1 A2 AA1 G1 A1 A2 AA1 G2 Table: TAB2 Col1 Col2 Col3 Col4 A1 A2 AA1 H1 A1 A2 AB1 H2 How to write a query to get Expected Result as:…
Mysql – Keep only groups in a SQL view that have at least one bigger value then a certain condition
I have SQL view data_start with 3 columns CALMONTH, COSTCENTER, Kontonummer Sample data: CALMONTH COSTCENTER Kontonummer ------------------------------- 202301 A AA 202302 A AB 202101 B BA 202012 B BB 202204 C CA 202312 C CB ... How can I keep…
Mysql – Divide results of a query in two different columns
I have the following result of a query: P2_AU_CE P2_03 P2_AU_CE P2_04 P2_CN_MOCE_001 P2_04 I would like to have the result shown this way instead: P2_AU_CE P2_03 P2_04 P2_CN_MOCE EMPTY P2_04
odbc_execute, odbc_fetch_row and odbc_result at the same time – PHP
I have a prepared statement built inside a class: function reader($ser) { $pstmt=odbc_prepare($this->conn,'SELECT TOP 1 "name" FROM '.$this->table.' WHERE "surname" LIKE ? '); return odbc_execute($pstmt,array("$ser")); } And gets its $ser through a post $serTab=$product->reader($ser); Example $ser : $ser=' '3221252''; When…
odbc doesn't work with Turkish characters – PHP
This is my code: odbc_exec($conn,"SET client_encoding='UTF-8'"); $viewTablo= odbc_exec($conn,"SELECT A FROM B WHERE A='ÇŞÖ'"); Odbc execute doesn't work with that 'ÇŞÖ' or any other Turkish character. How do I fix this? Edit: I cannot change anything inside the database. Code below…
Postgresql – Left join on single record
I have the next table that stores events: (simplified structure) ID User Action Timestamp 12 user1 END 2022-01-01 05:00 43 user1 START 2022-01-01 04:00 54 user1 END 2022-01-01 03:00 13 user1 START 2022-01-01 02:00 I need to join 2 events…