KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Questions tagged
subquery
33 questions
Follow Tag
Sort by:
Newest
Votes
Active
9
votes
1
answers
subquery - how to refer to outer query value
sql
sql-server
subquery
asked 2013-06-17T04:15:46.087
23
votes
4
answers
Can HQL Select on the result set of another query?
java
hibernate
subquery
hql
asked 2013-04-03T08:33:03.390
14
votes
4
answers
How to update column in a table from another table based on condition?
sql
sql-server
sql-update
subquery
multiple-tables
asked 2012-09-11T05:04:51.320
22
votes
1
answers
spring-data subquery within a Specification
spring
subquery
criteria-api
spring-data
asked 2012-08-21T19:13:34.240
331
votes
4
answers
Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
sql
sql-server
t-sql
subquery
common-table-expression
asked 2012-06-23T12:36:14.007
47
votes
2
answers
select count(*) from select
sql
sql-server
t-sql
subquery
asked 2012-05-03T20:50:09.920
16
votes
2
answers
MySql Select, Count(*) and SubQueries in Users<>Comments relations
mysql
sql
subquery
aggregate-functions
asked 2012-04-05T04:05:13.113
79
votes
7
answers
MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows?
mysql
select
subquery
insert-into
asked 2012-02-23T22:37:56.557
32
votes
2
answers
Example of an Oracle PIVOT clause with subquery
sql
oracle-database
syntax
subquery
pivot
asked 2012-01-06T15:11:58.270
15
votes
5
answers
Very slow delete on mysql base with subquery
mysql
subquery
config
sql-delete
asked 2011-09-09T11:48:57.467
13
votes
4
answers
JPQL / QueryDSL: join subquery and get aliased column
subquery
jpql
querydsl
asked 2011-08-04T13:16:31.880
9
votes
26
answers
sql sub-queries
sql
subquery
asked 2011-06-17T12:27:12.713
171
votes
10
answers
MySQL - SELECT WHERE field IN (subquery) - Extremely slow why?
mysql
subquery
where-in
asked 2011-05-26T07:53:23.047
14
votes
2
answers
MySQL Subquery with main query data variable
mysql
select
subquery
asked 2011-05-19T18:08:45.950
12
votes
3
answers
MySQL subquery to refer to field in parent query
mysql
subquery
asked 2011-04-25T17:55:01.873
14
votes
4
answers
How to use result of an subquery multiple times into an query
mysql
sql
subquery
asked 2011-04-20T13:22:32.373
22
votes
5
answers
Is it possible to use a Stored Procedure as a subquery in SQL Server 2008?
sql-server
stored-procedures
subquery
asked 2011-02-03T17:40:32.713
19
votes
4
answers
How can I extract the values from a record as individual columns in postgresql
postgresql
subquery
row
record
asked 2011-01-15T16:18:38.093
525
votes
3
answers
Nested select statement in SQL Server
sql
sql-server
nested
subquery
querying
asked 2011-01-07T20:27:26.240
38
votes
9
answers
WHERE col1,col2 IN (...) [SQL subquery using composite primary key]
sql
subquery
composite-primary-key
asked 2011-01-07T04:14:15.713
70
votes
4
answers
How to write Subqueries with In-Expressions in JPA 2.0, Criteria API?
jpa
subquery
jpa-2.0
criteria-api
in-subquery
asked 2010-12-19T15:16:39.240
9
votes
3
answers
The purpose of SQL's EXISTS and NOT EXISTS
sql
mysql
subquery
exists
not-exists
asked 2010-12-16T21:40:31.357
63
votes
9
answers
How to reuse a result column in an expression for another result column
sql
postgresql
subquery
asked 2010-11-18T23:09:10.663
30
votes
3
answers
Quick Explanation of SUBQUERY in NSPredicate Expression
iphone
cocoa
cocoa-touch
subquery
nspredicate
asked 2010-09-28T08:36:43.727
13
votes
3
answers
Which is faster: JOIN with GROUP BY or a Subquery?
sql-server
sql-server-2008
join
group-by
subquery
asked 2010-07-01T08:23:24.290
23
votes
4
answers
Is there a way to give a subquery an alias in Oracle 11g SQL?
sql
oracle-database
subquery
oracle11g
table-alias
asked 2010-06-16T23:35:44.817
13
votes
2
answers
SQL Oracle LEFT JOIN and SUBQUERY error: ORA-00905: missing keyword
sql
oracle-database
subquery
left-join
ora-00905
asked 2010-04-02T20:02:36.570
10
votes
10
answers
Why or why not do an ORDER BY in a subquery?
sql
subquery
sql-order-by
asked 2010-01-20T14:15:06.543
9
votes
5
answers
Can i force mysql to perform subquery first?
sql
mysql
subquery
asked 2009-11-19T21:29:07.190
11
votes
2
answers
SQL: "NOT IN" alternative for selecting rows based on values of *different* rows?
mysql
performance
subquery
asked 2009-08-17T04:29:39.353
11
votes
3
answers
How can I concatinate a subquery result field into the parent query?
sql-server
sql-server-2008
subquery
concatenation
asked 2009-06-19T07:27:41.630
9
votes
7
answers
How to convert a SQL subquery to a join
sql
sql-server
join
subquery
asked 2009-03-02T00:55:28.187
860
votes
18
answers
MySQL Error 1093 - Can't specify target table for update in FROM clause
mysql
subquery
sql-delete
mysql-error-1093
asked 2008-09-05T10:03:46.590