How to fetch records from a One to Many relationship table.
eg: wanna get details of all orders for a specific customer.
(do not want repeatation of master table records for child
table records)
Answer Posted / jagadeesh
SubQuery
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What do you mean by SQL injection attack?
How many tables can be joined in SQL Server?
How will you optimize a stored procedure optimization?
How to update values in a table with update statements in ms sql server?
What is the use of partition by in sql server?
Explain what is cte (common table expression)?
What are different types of statement?
What is the difference between left and right outer join?
How do I partition a table in sql server?
What are the properties of the relational tables?
How would you go about developing a ssrs report?
Explain about thread and memory management process of SQL?
Explain the difference between delete,drop and truncate in SQL Server?
Determine how to use the inserted and deleted pseudo tables?
Tell me about builtinadministrator?