ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashish Kulkarni <kulkarni_ash1...@yahoo.com>
Subject Re: [OT] Need help with SQL Query
Date Fri, 24 Feb 2006 18:28:29 GMT
Hi
I used the following sql statement to get it working
select date, time, name from mytable
number=123 order by date, time
FETCH FIRST 1 ROWS ONLY 


--- Nathan Maves <Nathan.Maves@Sun.COM> wrote:

> A little hasty with my answer...
> 
> The query I gave could give you results from two
> different rows.
> 
> Having a date and time column is problematic.  I
> would just use a  
> date column that included the time or a timestamp.
> 
> If there is only one column to worry about then you
> could do
> 
> select date, name from mytable where number = 123
> and date = (select  
> min(date) from mytable where number = 123)
> 
> nathan
> 
> 
> On Feb 24, 2006, at 9:25 AM, Nathan Maves wrote:
> 
> > You almost had it :)
> >
> > select min(date), min(time), name from mytable
> where number = 123  
> > group by name
> >
> >
> > Nathan
> >
> > On Feb 24, 2006, at 8:58 AM, Ashish Kulkarni
> wrote:
> >
> >> Hi
> >> I have a table with 4 columns number, name, date,
> >> time, it is not unique so can have multiple
> entries
> >> for one name at different date and time.
> >> I need to find out the first instance of name for
> that
> >> number in this table, or get the name with
> minimum
> >> date and time
> >> i can do
> >> select min(date), min(time) from mytable where
> >> number=123
> >> this will give me the min date and time , but how
> can
> >> i get the name also,
> >> for example
> >> select min(date), min(time), name from mytable
> >> number=123
> >> wont work
> >>
> >> Ashish
> >>
> >>
> __________________________________________________
> >> Do You Yahoo!?
> >> Tired of spam?  Yahoo! Mail has the best spam
> protection around
> >> http://mail.yahoo.com
> >
> 
> 


A$HI$H

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Mime
View raw message