Answer Posted / g.ramesh
It produce Result Set Which contains matched rows and right
table unmatched rows.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How can we solve concurrency problems?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Does view occupy space?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
do you know how to configure db2 side of the application? : Sql server database administration
Disadvantages of the indexes?
When should you use an instead of trigger?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Explain system functions or built-in functions? What are different types of system functions?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How raid can influence database performance?
How to convert character strings into numeric values?
List the ways in which dynamic sql can be executed?
What is subquery? Explain the properties of a subquery?
How can you append an identity column to a temporary table?
