Tag: query


Found 386 results for 'query'.


1) postgresql - Unique array values for this string_to_array
2) postgresql - Postgresql: most common values in array column
3) postgresql - Using postgres to select a filtered array
4) postgresql - How to loop through JSON array of JSON objects to see if it contains a value that I am looking for in postgres?
5) postgresql - Postgres group and aggregate(sum) JSONb arrays and non JSONb properties
6) mysql - MySQL - Maintain History of Records but Using Most Recent
7) postgresql - Postgres Query Array Column with Array
8) query - How to find the most common strings between rows
9) postgresql - How to address aggregate fanout in the below query
10) mysql - How to get all non deleted messages from one user
11) mysql - Error while importing a ".sql" file in database
12) join - SQL Outer Join while conditioning on an extra column
13) postgresql - Create result set with all records from LEFT table, and from the RIGHT table only bring records that do no exist in left already
14) postgresql - How to join 2 tables and fill non matching entries with a date
15) postgresql - Difficult multi-directional join
16) mysql - Left join including nulls
17) postgresql - Gather values from different related rows with JSONB fields
18) query - Group json data in db using a query
19) sql-server - Is it possible to make a reference to the result of an aggregate function in a SELECT clause from the same SELECT clause?
20) postgresql - Postgres JSONB - Flatten nested objects and groupings
21) postgresql - general design pattern for smushing rows into one column
22) postgresql - (POSTGRES) ON CONFLICT ... WHERE condition doesn't seem to be working
23) query - Return only records with a date after the most recent September 1st
24) mysql - Update Mysql records using Same table but Based on same table record
25) postgresql - Querying the most recent records with two fields: datestamp and timestamp
26) mysql - How can I find the difference between queries that return multiple rows?
27) sql-server - How to update the datetime difference between all of the rows of a table?
28) sql-server-2012 - Update values from one table to another where key values are not unique
29) postgresql - Dynamically deciding which operator to use based on the type of the value at hand
30) mysql - Recursive query on a self-referential table where each node has one link to its child's node
31) mysql - What is this type of query called, and how can I formulate it?
32) mysql - SELECT for values in a table
33) postgresql - Querying for a specific language and if not found use default one instead
34) update - How to update one column with the value of another if one of their columns match
35) oracle - Procedure with "bind varibale" does not return the desired result set
36) oracle - Seperate value of a specific column with "," delimiter in Oracle using "Regular Expression"
37) oracle-11g-r2 - Query to find the "Number of days" a customer has an active card between a specified interval
38) oracle - PL-SQL "LAST_VALUE" function does not give the desired result
39) oracle - SQL queries to get the duplicate records based on trim
40) postgresql - How to use LIKE operator with multiple conditions at once in PostgreSQL
41) sql-server - T-SQL: Assign identifier to block of results
42) postgresql - Postgresql get rows based on minimum value
43) active-directory - Command line active directory query email address for username
44) postgresql - Postgres Case-Insensitive search for Jsonb column tag keys
45) join - Combining a parent table with multiple child tables
46) query - Full Outer Join in MS Access
47) join - Are there better alternatives rather than using a "Full outer join" when it is not possible to use a "left or right join"?
48) join - SQL query - Do I need a full join to produce this combined result?
49) query - SQL db query using UNION and Left Join
50) mysql - Column collision in Left join with many columns vs PHPMyAdmin resultset