Skip to content

Instantly share code, notes, and snippets.

@gintsgints

gintsgints/Works for oracle

Created August 30, 2015 10:42
Show Gist options
  • Save gintsgints/f0b3a46e237d64e46301 to your computer and use it in GitHub Desktop.
Save gintsgints/f0b3a46e237d64e46301 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Works for oracle
SELECT "Task".* FROM (
(
select * from ( SELECT "id", "title", "createdAt", "updatedAt", "UserId"
FROM "Tasks" "Task"
WHERE "Task"."UserId" = 2 AND ROWNUM <= 2
ORDER BY "Task"."title") ) UNION ALL (
select * from ( SELECT "id", "title", "createdAt", "updatedAt", "UserId"
FROM "Tasks" "Task"
WHERE "Task"."UserId" = 2 AND ROWNUM <= 2
ORDER BY "Task"."title") )
) "Task"
Generated:
SELECT "Task".* FROM (
(
SELECT "id", "title", "createdAt", "updatedAt", "UserId"
FROM "Tasks" "Task"
WHERE "Task"."UserId" = 1 AND ROWNUM <= 2
ORDER BY "Task"."title"
) UNION ALL (
SELECT "id", "title", "createdAt", "updatedAt", "UserId"
FROM "Tasks" "Task"
WHERE "Task"."UserId" = 2 AND ROWNUM <= 2
ORDER BY "Task"."title"
)
) "Task"
@gintsgints
Copy link
Author

Works too:

SELECT "Task".* FROM (
(
SELECT "id", "title", "createdAt", "updatedAt", "UserId"
FROM "Tasks" "Task"
WHERE "Task"."UserId" = 1 AND ROWNUM <= 2
) UNION ALL (
SELECT "id", "title", "createdAt", "updatedAt", "UserId"
FROM "Tasks" "Task"
WHERE "Task"."UserId" = 2 AND ROWNUM <= 2
)
) "Task"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment