tell me about select query

Question

RanjithKumar chiguruvada · Answer

Hi The SELECT statement is used to select data from a database. SQL SELECT Syntax SELECT column_name(s) FROM table_name and SELECT * FROM table_name I f we want to display the first and last name of an employee combined together the SQL Select Statement would be like SELECT first_name || ' ' || last_name FROM employee;

nallya · Answer

if u want to select specific column select empidempname from employee(tablename); or for whole table select * from employee;