SELECT NUM FROM (SELECT ID=ROW_NUMBER()OVER(ORDER BY ID),NUM FROM TB)T WHERE ID=2
DECLARE @I1 INT,@I2 INT,@I3 INT SELECT @I1=2,@I2=6,@I3=4 SELECT NUM FROM ( SELECT ROW_NUMBER() OVER (ORDER BY NUM ASC) 'ID',NUM FROM (SELECT @I1 'NUM' UNION ALL SELECT @I2 UNION ALL SELECT @I3) T ) T WHERE ID=2 --4
create FUNCTION getMiddle ( -- Add the parameters for the function here @a int,@b int,@c int ) RETURNS int AS BEGIN -- Declare the return variable here DECLARE @t table(id int identity(1,1),value int) insert into @t (value) select @a as c union all select @b union all select @c order by cdeclare @s int select @s=value from @t where id=2 RETURN @sEND GO
NUM
FROM
(SELECT ID=ROW_NUMBER()OVER(ORDER BY ID),NUM FROM TB)T
WHERE
ID=2
SELECT @I1=2,@I2=6,@I3=4
SELECT NUM FROM (
SELECT ROW_NUMBER() OVER (ORDER BY NUM ASC) 'ID',NUM FROM
(SELECT @I1 'NUM' UNION ALL SELECT @I2 UNION ALL SELECT @I3) T
) T WHERE ID=2
--4
(
-- Add the parameters for the function here
@a int,@b int,@c int
)
RETURNS int
AS
BEGIN
-- Declare the return variable here
DECLARE @t table(id int identity(1,1),value int)
insert into @t (value)
select @a as c
union all select @b
union all select @c
order by cdeclare @s int
select @s=value from @t where id=2 RETURN @sEND
GO