How to view the list of databases available select name from sys.databases; - To pick a database to work use testdb; - To view the tables available in the testdb database select table_name from ...

select *, row_number() over (order by cid desc) as num from items select * from (select *, row_number() over (order by cid desc) as RowNum from items) t2 where t2.RowNum=5 ...