what will be the output:
select 1 from emp
union all
select 2 from emp;
Answer Posted / ankush
it returns the number 1 same number columns as well as
union with the value 2 again with the same number of
columns the table emp have.
Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Which sql most popular?
The select into statement is most often used to create backup copies of tables or for archiving records?
Explain sql data types?
What is varchar sql?
How do I run a program in pl sql?
How can one get sql*loader to commit only at the end of the load file? : aql loader
How to test for null values?
Can we rename a column in the output of sql query?
What are analytical functions in sql?
Is sql sequential or random?
can sql servers linked to other servers like oracle? : Sql dba
What is mdf ldf and ndf?
Is hadoop a nosql?
What is Difference Between Unique and Primary Key Constraints?
Why we use stored procedure instead of query?