Top "Nested-queries" questions

Multi SELECT SQL statement

Writing my first nested SELECT statement and I'm hoping someone can help me out. I need to grab the CompanyCode …

sql-server nested-queries
How to give the output of the first query(which has two values) as the input to the second?

i get 2 names as the output of the first query.... eg: paul,peter now this should be the input for …

sql oracle oracle10g nested-queries
Mysql Nested query and GROUP BY

I am trying to perform the following query on my database :- SELECT source, Month as t1, GROUP_CONCAT(SELECT …

mysql sql nested-queries
How to use a subquery inside another subquery with three tables in mysql?

I have three tables in my database, see the structure below : users uid | fname | date_joined --------------------------------- 1 | john | 2013-08-25 01:00:00 2 | …

mysql sql database subquery nested-queries
Efficient way to get max date before a given date

Suppose I have a table called Transaction and another table called Price. Price holds the prices for given funds at …

sql-server nested-queries
Filtering / Querying by the Contents of a List in DynamoDB

I am attempting to filter a DynamoDB query by the contents of a Map contained within a List. Here's an …

amazon-dynamodb nested-queries nosql
Any way to merge two queries in solr?

In my project, we use solr to index a lot of different kind of documents, by example Books and Persons, …

lucene solr nested-queries
How to perform nested queries with Elastica Search and Symfony2

I have a recipe entity which have some tags (many to many mapping) and I want to search recipes by …

symfony elasticsearch mapping nested-queries