试试这个



INSERT INTO数据（SNO）

选择'C01'

union

select 'C02'



或



插入表（SNO）价值（C01，C02）

I want to create datatable in below format

SNO column rank
1 c01 c02 c03 10
c11 c12 c13
c223 c22 c23


So please help me my dear friends

Tanks in advance

Try this

INSERT INTO Data ( SNO )
select 'C01'
union
select 'C02'

OR

INSERT INTO Table ( SNO ) VALUES ( C01, C02)