Select rows

Databases
1

Hi

I have small doubt selecting rows from table.
table is like this
id,name,date,price,total
we used to write query as


Select `id`,`name`,`date` from `table`



Select Top 3 from `table`

for example
i like 2 to select rows of first two columns without specifying its name.

Thanks

2

Is this MySQL?

for example
i like 2 to select rows of first two columns without specifying its name.

Without specifying the column names? You can’t. Unless you use SELECT * which would select all columns.