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 ?

Solution 1

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

Solution 2

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.

Solution 3

For what it's worth:

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

Source

Comments

[Dan Bracuk]

My guess, repeat guess, is that it is a query that returns one row with one record. Something like select count(*) from etc.