08-08-2014, 11:26
|
|
|
חבר מתאריך: 24.02.06
הודעות: 3,210
|
|
ORACLE
ציטוט:
SELECT NUM1,NUM2,CURR_CHECKING,CHECKING,
CASE
WHEN CHECKING IS NULL THEN
(CASE WHEN LAG(NUM1) OVER (ORDER BY 1)= LAG(NUM2) OVER (ORDER BY 1) THEN 1 ELSE 0 END)
WHEN CHECKING<>CURR_CHECKING AND CURR_CHECKING<>0
THEN 1 ELSE
CASE WHEN CHECKING=1 AND CURR_CHECKING<>0 THEN CHECKING+1
ELSE 0
END
END CHECKING1
FROM
(
SELECT NUM1,NUM2,LAG(CHECKING) OVER (ORDER BY 1) CHECKING,CHECKING CURR_CHECKING
FROM
(
(
SELECT 1 NUM1, 2 NUM2, CASE WHEN 1=2 THEN 1 ELSE 0 END CHECKING
FROM DUAL
)
UNION ALL
(
SELECT 1 NUM1, 2 NUM2, CASE WHEN 1=2 THEN 1 ELSE 0 END CHECKING
FROM DUAL
)
UNION ALL
(
SELECT 1 NUM1, 2 NUM2, CASE WHEN 1=2 THEN 1 ELSE 0 END CHECKING
FROM DUAL
)
UNION ALL
(
SELECT 3 NUM1, 3 NUM2, CASE WHEN 3=3 THEN 1 ELSE 0 END CHECKING
FROM DUAL
)
UNION ALL
(
SELECT 2 NUM1, 2 NUM2, CASE WHEN 2=2 THEN 1 ELSE 0 END CHECKING
FROM DUAL
)
UNION ALL
(
SELECT 2 NUM1, 2 NUM2, CASE WHEN 2=2 THEN 1 ELSE 0 END CHECKING
FROM DUAL
)
UNION ALL
(
SELECT 1 NUM1, 2 NUM2, CASE WHEN 1=2 THEN 1 ELSE 0 END CHECKING
FROM DUAL
)
UNION ALL
(
SELECT 5 NUM1, 5 NUM2, CASE WHEN 5=5 THEN 1 ELSE 0 END CHECKING
FROM DUAL
)
)
)
|
התחלה....אבל יש בעיה קטנה, תנסה להמשיך מכאן, אני עייפתי
_____________________________________
-פעם היה מעט מידע ובאיכות, היום יש המון מידע ובשיטחיות.
|