Question : I’m looking to select data from a table that contains an ID, and an array of values. But […]
Tag: query
Sql, get category tree for values from one table, names and ids
Question : What I need I need select all ids or names from table “category” (all chidrens) until category_id is […]
T-sql: Select most specific match from table
Question : Apologies for the horrible title. I couldn’t come up with a better way to briefly describe the problem. […]
How do I join a parent table to two child tables without duplication?
Question : parent table id city_name zip_code 1 new york city 10001 2 los angeles 90001 3 chicago 60007 Customer, […]
Does using “qb_name()” hint (query block name) in a query have significant effect on performance?
Question : I’ve just become familiar with the hint “qb_name” (query block name) in Oracle and below you can see […]
How is data queried from a company’s in-house database server using SQL? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Optimizing nested SQLite query
Question : I have a SQLite table named hashbands that looks like this: hashband | file_id | window_id —————————— potato […]
Help with correction of writing SQL queries [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Find which numbers in [1, 161] are not in the result set?
Question : How to find which two number in [1, 161] is not in the result set? Can I find […]
How to get distinct count on sub table joined via two different way
Question : I have 3 below tables in my db CREATE TABLE main_table ( id SERIAL PRIMARY KEY, name VARCHAR(255) […]