Databases
StackOverflow2013
Postsdbo
PODisplay records from Master/Master-Detail Table using SQL query only
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODisplay records from Master/Master-Detail Table using SQL query only
    text
    copied!<p>I have a problem which I already solved using T-SQL(cursor &amp; loop).(SQL server 2005)</p> <p>But I am looking for the solution using SQL.</p> <p>I have a Master Table with a column say MasterRecord(all are unique and type Varchar and PK)</p> <pre><code>MasterRecord ------------ MRecord1 MRecord2 MRecord3 MRecord4 ................ .................. MRecord[n] </code></pre> <p>Now the Master-Detail table has two columns MasterRecord(Varchar &amp; FK) and DetailRecord(Varchar)</p> <pre><code>MasterRecord DetailRecord --------------------------------------------- MRecord1 MRecord1_DetailRecord1 MRecord1 MRecord1_DetailRecord2 MRecord1 MRecord1_DetailRecord3 MRecord1 MRecord1_DetailRecord4 MRecord2 MRecord2_DetailRecord1 MRecord2 MRecord2_DetailRecord2 MRecord2 MRecord2_DetailRecord3 MRecord2 MRecord2_DetailRecord4 ............................................... ................................................ MRecord[n] MRecord[n] _DetailRecord1 MRecord[n] MRecord[n] _DetailRecord2 MRecord[n] MRecord[n] _DetailRecord3 MRecord[n] MRecord[n] _DetailRecord4 </code></pre> <p>where [n] can be any number</p> <p>The problem is that for each unique Master Record, I should fetch the top 2 detail records</p> <p>O/P:</p> <pre><code>MasterRecord DetailRecord --------------------------------------------- MRecord1 MRecord1_DetailRecord1 MRecord1 MRecord1_DetailRecord2 MRecord2 MRecord2_DetailRecord1 MRecord2 MRecord2_DetailRecord2 MRecord3 MRecord3_DetailRecord1 MRecord3 MRecord3_DetailRecord2 ............................................... .............................................. MRecord[n] MRecord[n] _DetailRecord1 MRecord[n] MRecord[n] _DetailRecord2 </code></pre> <p>Hope I clearly explained my problem.</p> <p>Please let me know for further clarification.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload