Write a query to display serial number multiple times

       

1
2
2
3
3
3
4
4
4
4
5
5
5
5
5

select level l from dual connect by level<=5;

1

2

3

4

5

 

with t as (select level l from dual connect by level<=5)

select * from t t1,t t2

where t1.l<=t2.l

1   1

1   2

1   3

1   4

1   5

2   2

2   3

2   4

2   5

3   3

3   4

3   5

4   4

4   5

5   5

 

with t as (select level l from dual connect by level<=5)

select t2.l from t t1,t t2

where t1.l<=t2.l

order by 1;

 

1

2

2

3

3

3

4

4

4

4

5

5

5

5

5