I have the task of finding all unique data types in all the tables. This is how I wrote the SQL query: WITH UniqueColumnTypes AS ( SELECT table_name, COUNT(DISTINCT data_type) AS unique_types FROM information_schema.columns WHERE table_schema NOT IN ('pg_catalog', 'information_schema')…
In a Postgres db, I have a view called school_id_cards. The view captures a list of id cards per school and student in a school system. ID cards are periodically reissued to students, so there may be any number of…
I have a situation where I need to insert data into two tables, where the inserted data is derived from the same long sub query. I know that CTEs can be helpful in similar situations since you can define a…
I have a simple MySQL table which consists of a primary key ID field, a timestamp (integer) field, and a foreign key ID field (device_id). There are indexes on each of these columns: mysql> show indexes from device_heartbeats; +-------------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ |…
This is probably really simple, but I've been trying to figure this out for a while, maybe a fresh pair of eyes will/could help. http://sqlfiddle.com/#!9/557e5a/1 I have this table wherein I need to prioritize selecting Accounts that are Chequing first,…
I have an array in SQL like CREATE TABLE Table1 ( examples text ARRAY); INSERT INTO Table1 (examples) VALUES {t1,t2,t3}; I can't find a description of the correct syntax to do select * from Table1 where (values) in (anysome) examples…
I have a below Organisation table. ID Resource 1 Software Engineer 2 Tech Lead 3 Architect 4 Senior Software Engineer 5 HR I need to fetch this table using select query such that the output which i receive should have…
I'm trying to create an insert script to insert multiple rows and using "exists" condition, but it's returning me an error, and I don't know why, I have a query like this: INSERT INTO films (id, code, title, did, date_prod,…
I get the following error: PHP Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':name, :cate, :content, :thumbnail, :price,…
I have a table with year, area codes and each area code has 5 categories of age groups with people count as below. year areacode agegroup persons 2021 code 1 20-29 5 2021 code 2 30-39 11 2022 code 1…