Wednesday, 26 July 2023

N th TOP RECORD

select id, work

from (

  select id, work, row_number() over (order by work) as rn

  from x

) t

where rn = 1 -- or 2 or 3 ...

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Kiro - Core Features

What is Kiro Kiro is an innovative AI-powered IDE that revolutionizes software development through intelligent assistance and structured wor...

  • CACHING in Snowflake
    Result Cache Stores the results of a query (Cloud Services) Same queries can use that cache in the future Table data has not changed Micro-p...
  • List
    #Sample   thislist = [ "apple" , "banana" , "cherry" ] print ( "MyList : " , thislist ) ​ thislist...
  • Create Index
     CREATE INDEX sync_idx_abc ON schemaname.tablename(columnname);