What is the difference between join and union.
Answer Posted / haritha
we can join two tables by 'join' if they have common
field.we can union two tables irrespective of common field.
| Is This Answer Correct ? | 316 Yes | 148 No |
Post New Answer View All Answers
What is the use of sqldataadapter?
What is a dirty read sql?
what is timestamp in mysql? : Sql dba
How to get each name only once from an employee table?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
How do I view an execution plan in sql?
What port does sql server use?
What is the basic form of sql query?
Can there be 2 primary keys in a table?
what is view? : Sql dba
What are the disadvantages of file system?
What is sql partition function?
Where is all the data on the internet stored?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
how do you control the max size of a heap table? : Sql dba