-- Useless
select row_number() over(order by (select 1)) as rn
from sys.all_objects
for json auto
-- Useful
select (
select row_number() over(order by (select 1)) as rn
from sys.all_objects
for json auto
)
Code Example |
---|
Sql :: |
Sql :: |
Sql :: |
:: |
Sql :: |
:: delete from table and truncate table |
:: |
:: how to get one year old query from plan cache |
Sql :: shortcut run sql pgadmin |
:: oracle apex call duration |
:: |
:: |
Sql :: |
:: |
:: |
:: get statis values sql |
:: multiple like values for single column postgres |
:: |
Sql :: |
:: |
:: |
:: |
:: |
:: date query |
Sql :: |
Sql :: How to do a cumulative count using Raw SQl / Laravel - Eloquent ORM |
Sql :: |
:: composit key in sql |
:: |
:: |