Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
  b=q63f6Ye+oSGISVW4g1EtLrXynPhHD7Un1x4gggi5xv5RflaPa3fPUa1P0EWtzAimFqdEGPBbDJKqCb++qEqyJxn+CusFa+xqSMBU3rLE/0RItlhB/q+6TW4s2LEOuDCg1+xAFgCycKjb79wcLumGb6RjGsspi5145OH5oR4hxvE=
  ;
Message-ID: <20060224155816.17344.qmail@web35302.mail.mud.yahoo.com>
Date: Fri, 24 Feb 2006 07:58:16 -0800 (PST)
From: Ashish Kulkarni <kulkarni_ash1312@yahoo.com>
Subject: [OT] Need help with SQL Query
To: user-java@ibatis.apache.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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