Sign in
apache
/
drill-test-framework
/
b5ed55188c294aa172ccc7d30e7981884fedc8f0
/
.
/
framework
/
resources
/
Functional
/
subqueries
/
subquery_in_select
/
agg_func_min_in_subquery.sql
blob: 1417e251959bcbea9762907e6058953b62baa534 [
file
] [
log
] [
blame
]
SELECT
m
.
employee_id
,
(
SELECT
MIN
(
sb
.
full_name
)
as
min_concat
FROM
cp
.`
employee
.
json
`
as
sb
)
as
min_f_name
FROM
cp
.`
employee
.
json
`
as
m
WHERE
m
.
gender
LIKE
'F'
LIMIT
5
;