On Jun 18, 12:57 pm, Michael Moore <michaeljmo...@gmail.com> wrote:
> Don't be sorry, I just thought you might like to know that it sounds really
> weird to western ears. :-)
>
> adding 2008 into the mix makes it a totally different problem. I'll look at
> it.
> Regards,
> Mike
>
>
>
> On Thu, Jun 18, 2009 at 10:49 AM, Mouhammed Iyad <iya...@gmail.com> wrote:
>
> > Sorry Mike,
>
> > I used to send it in my formal business emails in my company & every
> > one in this company are using it,
> > but that don't make me right,
>
> > your right thanks for the note,
>
> > any way about the query,
>
> > the table is an example of what I really has,
> > if I added these values to your example,
>
> > INSERT INTO samp
> > VALUES ('8-5',101,102);
> > INSERT INTO samp
> > VALUES ('8-6',102,103);
> > INSERT INTO samp
> > VALUES ('8-7',103,104);
> > INSERT INTO samp
> > VALUES ('8-8',104,105)
>
> > the query will include values from 2008
>
> > I want when I the following results
> > 8 101 105
> > 9 300 330
>
> > Regards,
> > Iyad
>
> > On 18/06/2009, Michael Moore <michaeljmo...@gmail.com> wrote:
> > > Muhammad,
>
> > > Please forgive me for this unsolicited advice, but you might not wish to
> > > start your email with "Dears". "Dears" is appropriate to address close
> > loved
> > > ones, such as your children or wife. It's a bit like calling us habiby.
>
> > > There is a formal way that we sometimes use to start letters to business
> > > associates, for example,
>
> > > Dear Jack,
>
> > > This is a formality and it does not mean that Jack is dear to you. You
> > could
> > > start with
>
> > > Dear list members,
> > > Dear recipients,
>
> > > but even this seems excessively personal.
>
> > > I would just start with:
>
> > > Hello,
>
> > > Regards,
> > > Mike- Hide quoted text -
>
> - Show quoted text -
SQL> with minact as(
2 select substr(act,1,4) yr, min(act) mact
3 from samp
4 group by substr(act,1,4)
5 ),
6 maxact as(
7 select substr(act,1,4) xyr, max(act) xact
8 from samp
9 group by substr(act,1,4)
10 )
11 select yr, s1.beg, s2.nd
12 from samp s1, samp s2, minact, maxact
13 where s1.act = mact
14 and s2.act = xact
15 and substr(s1.act,1,4) = yr
16 and substr(s2.act,1,4) = yr
17 /
YR BEG ND
---- ---------- ----------
2009 300 330
2008 101 105
SQL>
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
