Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

This challenge involves assigning food packets to birds from two different baskets. Your job is to read the input table and produce the required result set using a single PLSQL query.

PLSQL Challenge 1 - Pair-wise and ordered assignment of objects from two different lists

Solution 16 By Niladri Biswas

Oct 21 2011 9:03AM by Niladri Das Gupta   

SELECT 	
	b.Code
	,b.Name AS Bird
	,g.Grain
	,f.Fruit
FROM PLC1_BIRDS b
LEFT JOIN
(	
	(SELECT 
		DENSE_RANK() OVER(PARTITION BY Code ORDER BY Fruit) RowNumber
		,Code
		,Fruit
	FROM PLC1_FRUITS) f
	FULL JOIN 
	(SELECT 
		DENSE_RANK() OVER(PARTITION BY Code ORDER BY Grain) RowNumber
		,Code
		,Grain
	FROM PLC1_GRAINS) g
	ON f.Code = g.Code AND f.RowNumber = g.RowNumber
)
ON b.CODE = g.Code 
OR  b.CODE = f.Code;

Tags: DENSE_RANK(), FULL JOIN


Niladri Das Gupta
7 · 21% · 6710
0
Liked



Submit

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]