Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Frequency Distribution
Hello, I have a simple table, it has two coloumns [Product] [DateTime], in this table row updates in random time (it could update every second or no updates for several seconds). How can I get a frequency distribution (number of product) in evry 10 seconde ? Product,DateTime A 10/15/2009...- arfasih
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Confidence Interval
Hello How can I calculate Confidence Interval By MS SQL? I have an Array of Data, and I'm looking for a method Like Confidence Interval in Excel. Thank you very much in advance, Regards, Fasih- arfasih
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Counting values in time period
Hello, I have a table with two fields. products and Datetime. how can I count the number of products on each hour ? from 6:00 AM until 6:00 PM for example. Table 1 ---Products---|---DateTime---- A 2009-10-20 6.00.01 A 2009-10-20 6.10.10 B 2009-10-20...- arfasih
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Counting values in time period.
Hello, I have a table with two fields. procudts and DateTime. how can I count the number of procudts on each hour ? from 6:00 AM until 6:00 PM for example. Table 1 ---Products---|---DateTime---- A 2009-10-20 6.00.01 A 2009-10-20 6.10.10 B 2009-10-20... -
SQL "Select Query" question.
Hello I have a Table with two field and one million row. List of this table has been generated by SQL "Group By" command. it's looks like below table, now, I want to select those rows of the table which the difference between the value of each row and previous row in second fields (and same...
