Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Генерация чисел в диапазоне в MS SQL
set nocount on; use rextester; if object_id('dbo.n','IF') is not null drop function dbo.n; go create function dbo.n(@ bigint,@f bigint)returns table as return with a as(select 0 c union all select 0), b as(select 0 c from a,a t), c as(select 0 c from b,b t), d as(select 0 c from c,c t), e as(select 0 c from d,d t), f as(select 0 c from e,e t), v as(select top(@f-@+1)0 c from f) select row_number()over(order by(select 0))+@-1 n from v; go select '050'+replace(str(min(n),7),' ','0'), '050'+replace(str(max(n),7),' ','0'), count(*) from dbo.n(0,9999999);
run
|
edit
|
history
|
help
0
SQL_RankingFunctions
Q2_15min
Return a single column that matches a parameter
New
Lab 4
COMPUTED COLUMN
megha
top 3 salaries from each dept
base de datos dbfloreria
PIVOT AND UNPIVOT USING XML PARSING