How to get tsql TOP PERCENT with OFFSET

4 votes

1 answer

1542 views

                              select top 10 percent *
    from sys.databases
    order by database_id
    
I want to get the same 10 percent result using offset but this query works wrong

    offset 0 rows
    fetch next (select cast((count(*) * 10/100) as int ) from sys.databases) rows only

Asked by igelr (2162 rep)

Mar 13, 2019, 08:45 AM
Last activity: Mar 14, 2019, 08:16 AM

How to get tsql TOP PERCENT with OFFSET

Related Questions