I want to create a new table with all the data from an existing table. I understand that I can use
create table new_table_name
select * from old_table

But I want to check whether there is any row in the old_table first. Can this be done in sql? Thanks, Rong