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 2005 Forums
 .NET Inside SQL Server (2005)
 How to select n number of records in Table?

Author  Topic 

umapathy
Starting Member

24 Posts

Posted - 2007-03-19 : 11:04:17
Dear Friends!

i have one table namely details
empid type qty
emp1 bucket 5
emp2 bucket 5
emp4 Book 5
emp5 Lux 5
.. .. ..
.. .. ..
nenp n n


Every end of the day i need select total no of type and qty.i have milions of records in the table
ex bucket 100
book 300

How it is possible

Regards
Umapathy

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-19 : 11:06:12
[HINT]
- SUM()
- GROUP BY
[/HINT]


KH

Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-19 : 11:13:10
No information available about DATETIME column?
How do you know when it is a new day?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -