On Thursday, January 22, 2015, tsunghan hsieh <tsunghan(dot)hsieh(at)gmail(dot)com>
wrote:
> Hi
>
> I have a table which just has one column as following in Original Table. I
> wanna duplicate all of data for few times and with same order as following
> in New Table. Is there anyone who can help me? Thanks
>
> Han
>
> Original Table
> 23
> 45
> 65
> 22
>
> New Table
> 23
> 23
> 23
> 45
> 45
> 45
> 65
> 65
> 65
> 65
> 22
> 22
> 22
> 22
>
Tables do not have order.
Cross join.
David J.