What is the syntax of SELECT statement for retrieving more than 1 columns? : )

Answer 1

Just list them separated by a comma:

SELECT column1, column2, column3 FROM table1

Answer 2

If you want, for example, to select name, surname from the 'student' table, is:

SELECT name, surname
FROM student

Answer 3

if you want to retrieve more than 1 column, then u need to specify the column name.. or else you can use * to retrieve all the columns of the table
eg: select * from tablename

Answer 4

select the specific column by using select command
like dog is name of database & it contain column breed ,weight ,height . so code is

select height,breed from dog

Answer 5

select empid,empname from employee
empid and empname are columns...

Answer 6

if you want to select all the columns
SELECT *
FROM tablename