Query to display the sequence of numbers:

SELECT (100*t3.a+10*t1.a+t2.a)
FROM
temp t1
CROSS JOIN

temp t2
CROSS JOIN
temp t3
(or)

SELECT cast((t1.a||t2.a||t3.a) as integer)
FROM
temp t1
CROSS JOIN

temp t2
CROSS JOIN

temp t3

Table: temp




a
0
1
2
3
4
5
6
7
8
9

No comments:

Post a Comment