min date from data range

[rk68]

How do I extract min date from a given date range ?
I have data of members from year 2005 to till date.
I have to extract data for members with min date for the period starting april 1 2012.

TIA
RAJ

 

[SantaMufasa]

Raj,

I'm sure we can help. Could you please post minimal code for your scenario that includes the table-creation code and several rows of sample values:

CREATE TABLE <table_name> (<col 1> <data type>, <et cetera>);

INSERT INTO <table_name> VALUES (<col-1 value>, <et cetera>);
INSERT INTO <table_name> VALUES (<col-1 value>, <et cetera>);
INSERT INTO <table_name> VALUES (<col-1 value>, <et cetera>);
INSERT INTO <table_name> VALUES (<col-1 value>, <et cetera>);
INSERT INTO <table_name> VALUES (<col-1 value>, <et cetera>);

Also please include the SQL query that you have unsuccessfully tried so far.

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.