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 ?

Lakin

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

Answer 1

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

Cobber

Answer 2

For what it's worth:

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

Source

Offshore

Answer 3

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.

Hollandia