Questions tagged [subquery]

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

Questions tagged subquery