Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > first minimum d...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 10982 of 11205
 Post > Topic >>

first minimum date in the column for each distinct column a value

by rajesh <techsatish@[EMAIL PROTECTED] > Apr 21, 2008 at 11:21 AM

Hi ,

i want to select the first minimum date in the column d for each
distinct column a value.
how i can do that in a sql query.

xyztable

Column a Column b    Column c                 Column d

6014350	-10	2008-02-22 00:00:00	2008-02-12 00:00:00
6014350	4	2008-02-22 00:00:00	2008-02-26 00:00:00
6014472	-7	2008-03-06 00:00:00	2008-02-28 00:00:00
6014472	32	2008-03-06 00:00:00	2008-04-07 00:00:00

i need the results like this....

Column a Column b    Column c                 Column d
6014350	-10	2008-02-22 00:00:00	2008-02-12 00:00:00
6014472	-7	2008-03-06 00:00:00	2008-02-28 00:00:00

Thanks
Rajesh kumar




 2 Posts in Topic:
first minimum date in the column for each distinct column a valu
 rajesh <techsatish@[EM  2008-04-21 11:21:56 
Re: first minimum date in the column for each distinct column a
 "Plamen Ratchev"  2008-04-21 14:46:58 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup
Contact
tan13V112 Sun Jul 6 4:48:32 CDT 2008.