VisibilityUnlisted - anyone with the share link can access
DescriptionThis query attempts to get the first line from an already sorted resultset using rownum=1.
AreaSQL General
Contributor
CreatedTuesday November 24, 2020
Statement1
with products (sku,price) as (
select 'toothbrush', 2.99 from dual union all
select 'bicycle', 149 from dual
)
select * from (select sku from products order by price) where rownum=1