What is a "Scalar" Query?

Question

I am using LLBLGEN where there is a method to execute a query as a scalar query. Googling gives me a definition for scalar sub-query, are they the same ?

My guess, repeat guess, is that it is a query that returns one row with one record. Something like select count(*) from etc. — Dan Bracuk, Dec 06 '13 at 13:27

score 49 · Accepted Answer · answered Dec 06 '13 at 13:27

49

A scalar query is a query that returns one row consisting of one column.

answered Dec 06 '13 at 13:27

Andomar

232,371
49
380
404

score 10 · Answer 2 · edited Jun 20 '20 at 09:12

10

For what it's worth:

Scalar subqueries or scalar queries are queries that return exactly one column and one or zero records.

Source

edited Jun 20 '20 at 09:12

Community

1
1

answered Jun 14 '17 at 23:25

fwiw

622
11
16

score 8 · Answer 3 · edited Jun 25 '15 at 20:49

8

A scalar method is used for aggregate functions such as max, min, sum, avg and so on. Whenever you want to return a single value after execute the query.

edited Jun 25 '15 at 20:49

marc_s

732,580
175
1,330
1,459

answered Jun 21 '15 at 05:34

Aslam Khan

81
1
1

What is a "Scalar" Query?

3 Answers3

Linked