Skip to content

Instantly share code, notes, and snippets.

@carlosspohr
Created September 27, 2013 17:12
Show Gist options
  • Select an option

  • Save carlosspohr/6731854 to your computer and use it in GitHub Desktop.

Select an option

Save carlosspohr/6731854 to your computer and use it in GitHub Desktop.
Forçar N linhas.
SELECT
*
FROM
(
SELECT
1 line
UNION SELECT
2
UNION SELECT
3
UNION SELECT
4
UNION SELECT
5
UNION SELECT
6
UNION SELECT
7
UNION SELECT
8
UNION SELECT
9
UNION SELECT
10
UNION SELECT
11
UNION SELECT
12
UNION SELECT
13
UNION SELECT
14
UNION SELECT
15
UNION SELECT
16
UNION SELECT
17
UNION SELECT
18
UNION SELECT
19
UNION SELECT
20
UNION SELECT
21
UNION SELECT
22
UNION SELECT
23
UNION SELECT
24
UNION SELECT
25
UNION SELECT
26
UNION SELECT
27
UNION SELECT
28
UNION SELECT
29
UNION SELECT
30
UNION SELECT
31
UNION SELECT
32
UNION SELECT
33
UNION SELECT
34
UNION SELECT
35
UNION SELECT
36
UNION SELECT
37
UNION SELECT
38
UNION SELECT
39
UNION SELECT
40
UNION SELECT
41
UNION SELECT
42
UNION SELECT
43
UNION SELECT
44
UNION SELECT
45
UNION SELECT
46
UNION SELECT
47
UNION SELECT
48
UNION SELECT
49
UNION SELECT
50
UNION SELECT
51
UNION SELECT
52
UNION SELECT
53
UNION SELECT
54
UNION SELECT
55
) line
WHERE
line <= :PARAM
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment