There is a table1 with records (1,2,3,4,5,6) and table2
with records (4,5,6,7,8,9).write a query so as to get the
result as 1,2,3,4,5,6,7,8,9

Answer Posted / meghag

Also, use order by clause with union

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to add additional conditions in SQL?

578


Write a program using SQL queries to find a unique entry in a table.

532


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1500


How to change the password of a login name in ms sql server?

549


Will the writetext statement activate a trigger?

559






What are different types of database indexes?

517


How to rebuild master databse?

653


Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

507


How to start and end transact-sql statements?

571


how can you attach more than 20 ldf files in sql server

1559


What is exclusive locks?

529


Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

578


Explain security with sql azure?

161


How to create a stored procedure with a statement block in ms sql server?

568


What are data files?

571