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)
- 2 Answers
- 4356 Views
- I also Faced
- E-Mail Answers
Answer Posted / jagadeesh
SubQuery
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What can be used instead of trigger?
Can we check locks in database? If so, how can we do this lock check?
What is primary key and example?
What are sp_configure commands and set commands?
Difference between primary key and clustered index?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
How to concatenate two character strings together?
What is log in sql server?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
Explain linked server in sql?
What is acid properties?
How can you hide the sql server instances?
Do you know what is similarity and difference between truncate and delete in sql?
What is bcnf normalization form?
What does dml stand for?
