when wil we use select 1 from empselect 2 from emp.....(In real time)

when we will use select 1 from table_Name?

select 2 from Table_Name?

select 3 from Table_Name?

what is the use of those statements.

when will we use those statement , where it useful in realtime.

i need explanation with clearly.