SQL面試題總結

--SQL SERVER中的函數遞迴;--按1,1,2,3,5,8,13...等算出第30個出現的數字;IF EXISTS(SELECT * FROM SYSOBJECTS WHERE id = OBJECT_ID(N'P','FN'))BEGINDROP FUNCTION P;ENDGOCREATE FUNCTION P(@i INT)RETURNS INTAS BEGINDECLARE @RETURN INT;IF @i = 0BEGINSET @RETURN = 0;ENDELSE IF @i = 1BEGINSET @RETURN = 1;ENDELSEBEGINSET @RETURN = dbo.P(@i - 1) + dbo.P(@i - 2);ENDRETURN @RETURN;ENDGOSELECT dbo.P(30);GO--尋找31行到40行的資料SELECT * FROM (SELECT *,ROW_NUMBER() OVER(ORDER BY number ASC) AS id FROM dbo.spt_values) A WHERE id BETWEEN 31 AND 40;