View Single Post
  #2 (permalink)  
Old March 31st, 2005, 03:16 PM
shahchi1 shahchi1 is offline
Friend of Wrox
 
Join Date: Jan 2004
Location: , , USA.
Posts: 303
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Try this..not sure what databae are you using

SQL Server T-SQL Query

SELECT Sysno,Item_Number,[Description],Rate
From Table
Group By Sysno,Item_Number,[Description],Rate
Having Rate IS NOT NULL