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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Select only one record from row group

Author  Topic  sunin Starting Member 2 Posts Posted - 2001-07-10 : 05:18:18 I have a table like below Inoiveno PO Shipdate K001 A010 22/6/2001 K001 A012 24/6/2001 K001 A030 1/7/2001 K012 A017 12/5/2001 From thistable , I have to query invoiceno and shipdate which get only latest shipdate of that invioceno , how could I solve this problem ? Do I need to use cursor on this case ? Thanks Nin