Postgresql – How to get the average from multiple columns
I saw this answer how do I select AVG of multiple columns on a single row but I have some rows which is the value is 0 and it's throwing an error division by zero when I try to use…
Postgresql – How to allow a gender field to accept only two values?
The question: Add a gender field. Ensure the field will only accept ‘M’ or ‘F’ and the default value should be ‘F’ PostgresSQL code: alter table Patient add Gender varchar(1) default 'F' ,Check (Gender = 'M' or Gender = 'F');…
Mysql – SQL Query – calculate pct change between latest two years
I have a table in mysql database that has the following structure and data. City zip year value AB, NM 87102 2012 150 AB, NM 87102 2013 175 AB, NM 87102 2014 200 DL, TX 75212 2018 100 DL, TX…
Postgresql – how do i subtract row pairs in the same table in sql?
I have a table called activity that contains values like the following: userId | timestamp | action ---------------------------------------- 1 | 2022-10-18 10:00:00 | OPEN 2 | 2022-10-18 10:20:00 | OPEN 1 | 2022-10-18 10:05:00 | CLOSE 2 | 2022-10-18 10:22:00…
Postgresql – SQL: Summarize rows by column value, without using UNION
Im trying to write an sql statement which summarizes the count of rows by values in a specific column. I have several tables, starting with s0_ Every table has a huge amount of rows with multiple, different values in column…
mysql query GROUP BY trimed data column
i'm working with MYSQL, and have a problem with group by column that data has to be trimed first. here is my table: src dst source one some_character1/dst_one-random_value1 source one some_character1/dst_one-random_value2 source one some_character2/dst_two-random_value3 source two some_character4/dst_two-random_value1 source two some_character4/dst_three-random_value2…
Mysql – If result of subquery is > 1, don't use other results
I'm working on building this SQL function that is a lot more complex than what I'm usually used to, and I could really use some community eyes to bounce this off of. It's a question that is hard to word,…
Compare of imported databasea – (Fingerprinting possible?) – Ubuntu
Source: MS Access on Windows network share Target: MySQL/MariaDB on Ubuntu Tools: mdb-export, mysqlimport record count: 1,5 Mio + I wonder if there is a fast and reliable way of comparing the imported data records. Is there an SQL standard…
Mysql – Extract second level object from JSON while preserving first level key in return value
I'm trying to pull a value out of nested JSON inside a column. I get the return value, but I am unable to also pull the first JSON key that the value binds to. Query only pulls 1 row. Example…
Mysql – SQL condition on full name with no firstname/lastname order
Given a column named fullname, how can I filter on firstname/lastname with no order ? In the example below in javascript, the query is not valid when searching by lastname function getQuery(searchWord){ return `SELECT * FROM user WHERE fullname like…