Question : I am working in Oracle and trying to update a value in tableA to = ‘Y’ based on […]
Tag: subquery
Problem to select not in
Question : I want to display the values that are between 0 and 10 and dont exist in the current […]
PostgreSQL join subquery can’t restrict query
Question : I’m working on a check-splitting project that splits out amount owed for an activity. Users can be a […]
Optimize MySQL Query with multiple subqueries
Question : I have the following Query: SELECT p.id AS post_id, p.status, p.user_id AS post_user_id, ( SELECT pl.id FROM postlocks […]
Mysql query to get count result and group by
Question : I’ve got three tables with different records for users, User username | realname | date evn-az-3ju john 11/2012 […]
PostgreSQL query very slow when subquery added
Question : I have a relatively simple query on a table with 1.5M rows: SELECT mtid FROM publication WHERE mtid […]
Email open rate calculations in subqueries with postgres
Question : So I’m relatively new to PostgreSQL, but here we go: I have a pgsql database that is receiving […]
Call function where argument is a (sub)select statement
Question : My function takes an int4 as argument and returns a table: SELECT * FROM test_function(545421); — works fine […]
If a query contains two identical subqueries, will they both run?
Question : Say I have a SELECT query that contains two identical subqueries, like the below: SELECT (SELECT SUM(Price) FROM […]
how to solve slow running sub query TSQL
Question : I have a problem with a slow running query. I have analysed the query with the sql server […]