Join GitHub today
GitHub is home to over 20 million developers working together to host and review code, manage projects, and build software together.
first() query operator #1961
The SQL operator that take any Iterable or SQL subquery result and returns a single record.
It also could be implemented as (query) syntax. However I think this variant is less readable.
insert into UsesTool set CarId = first(select @Rid from Car where name='Mercedes' limit 1)
select from UsesTool where CarId = first(select @Rid from Car where name='Mercedes' limit 1)