Database DataWarehousing (MOSC)

MOSC Banner

SCRIPT WRITING CONTEST: How to write a select that retrieves all merchants that have transactions in

edited Oct 9, 2012 6:18AM in Database DataWarehousing (MOSC) 2 commentsAnswered
How to write a select that retrieves all merchants that have transactions in every day month but
stopped having transacon since day 25/26/27 of one month till end of monthin a specific time range.
Retrieve all table columns that match.

the time range is from month 03/2009  -  08/2009

Match:
1. Merchants that have at least 1 transaction on day 01, at least 1 transaction on day 02, ..., at least 1 transaction on day 24,
and that have no  txn starting on day 25 till end of month .

2. Merchants that have at least 1 transaction on day 01, at least 1 transaction on day 02, ..., at least 1 transaction on day 25,
and that have no  txn starting on day 26 till end of month .

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center