Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravids
Starting Member
2 Posts |
 Posted - 2005-06-08 : 04:11:23
|
| Hi all,I am taking below table as example Item date_of_soldApple 3/17/2004 12:06:08 PM Apple 3/17/2004 12:48:41 PM Apple 3/17/2004 1:06:23 PM Orange 10/30/2004 6:27:44 AM Orange 10/30/2004 6:27:59 AM Orange 10/30/2004 4:00:08 PM Orange 10/30/2004 6:18:07 PM Orange 1/10/2005 3:21:00 PM Grapes 9/19/2004 4:17:39 PM Grapes 9/19/2004 4:46:37 PM Grapes 9/19/2004 11:47:58 PM I want to write a query which gives first sold date(considering the time also) for any item..please help meThank youRavi |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-06-08 : 04:17:43
|
| this is obviously homework, but to help you out,search select, max, top, order by in BOL to construct your query--------------------keeping it simple... |
 |
|
|
ravids
Starting Member
2 Posts |
Posted - 2005-06-08 : 04:57:13
|
| Thanks for ur information jen i will work on thatRavi |
|
|
|
|
|
|
please help me to write Query