tell me about select query
tell me about select query
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
RanjithKumar chiguruvadaPosted Sep 18, 2012, 3:07 AM
If 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;
nallyaPosted Sep 18, 2012, 2:36 AM
select empid,empname from employee(tablename);
or for whole table
select * from employee;