Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12 Answers
- 18129 Views
- RBS, I also Faced
- E-Mail Answers
Answer Posted / guru
Union gives the result in two records
We have to use cross join like below
select * from table1,table2
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What are the advantages dts has over bcp?
Do you know what is replace and stuff function in sql server?
When you should use a low fill factor?
What is it’s similarity with sql server?
What is the difference between locking and multi-versioning?
What gets stored inside msdb database?
What is the log shipping?
What is GUID in sql server?
What are page splits?
what is the maximum size of a row? : Sql server database administration
What do we need queues in sql service broker?
what are the new features in SSRS?
Tell me what are cursors and when they are useful?
What are the database roles? : sql server security
