Pastebin
API
tools
faq
paste
Login
Sign up
SHARE
TWEET
Firebird recursive query
HwapX
Jan 8th, 2014
169
0
Never
Add comment
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!
SQL
0.16 KB
| None
|
0
0
raw
download
clone
embed
print
report
WITH
recursive items
(
id
,
caption
,
parent
)
AS
(
SELECT
*
FROM
test
WHERE
id
=
:p
UNION
ALL
SELECT
*
FROM
test t
JOIN
items i
ON
i
.
PARENT
=
t
.
id
)
SELECT
*
FROM
items;
Advertisement
Add Comment
Please,
Sign In
to add comment
Public Pastes
13.OOO IN 2DAY
CSS | 27 min ago | 0.65 KB
✅ API Flaw Technique
CSS | 27 min ago | 0.65 KB
Big $$$ Strategy
CSS | 28 min ago | 0.65 KB
13.OOO IN 2DAY
CSS | 1 hour ago | 0.65 KB
✅ API Flaw Technique
CSS | 1 hour ago | 0.65 KB
Big $$$ Strategy
CSS | 1 hour ago | 0.65 KB
13.OOO IN 2DAY
CSS | 2 hours ago | 0.65 KB
✅ API Flaw Technique
CSS | 2 hours ago | 0.65 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the
Cookies Policy
.
OK, I Understand
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!