Please help me... - SQL Server Forums

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

Transact-SQL (2000)

Please help me...

Author

Topic

great_mamun
Starting Member

14 Posts

Posted - 2008-09-16 : 04:20:12

Dear All,
I ve to tables t1

t1 (id,date,qnty,r_id)
1, 6/6/2008, 20, 5
2, 6/6/2008, 20, 5
3, 6/6/2008, 20, 5

1, 7/7/2008, 10, 6

2, 8/8/2008, 5, 7
3, 8/8/2008, 5, 7

I want to show
(date, qnty, r_id)
6/6/2008, 20, 5
7/7/2008, 10, 6
8/8/2008, 5, 7

the distinct value.

please someone help me regarding this matter.

Best Regards,
Abdullah Al Mamun

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-09-16 : 04:24:20

select distinct date, qnty, r_id from t1

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources