Toggle navigation
Dashboard
Dashboard Tracker
Add / Edit My Forums
System Announcements
Discussion
Active Thread Feed
Top Threads Today
Top Threads This Week
Top Threads Library
Go!
View All
View All
Login
Logout
Home
Forums Index
Server Side
/
Databases
12:25 pm Sep 21, 2026
This page requires javascript.
Forum Moderators:
open
Message Too Old, No Replies
Find rows for a value with different dates in the same table
Need a single query/subquery
dougmcc1
Msg#:3554720
4:44 pm on Jan 22, 2008
(gmt 0)
Assuming the fields in a single table are Date¦Product¦Sales, I want to return all products that had fewer sales yesterday than the day before.
What would be the query for this?
Thanks in advance.
dougmcc1
Msg#:3554745
5:04 pm on Jan 22, 2008
(gmt 0)
Also, how do I return the difference in sales, ordered by difference in sales descending?
Join The Conversation
Register
For Free! -
Become a
Pro Member
!
See forum categories
-
Enter the Forum
Moderators and Top Contributors
Moderator List
| Top Contributors:
This Week
,
This Month
,
Aug
,
Jul
,
Archive
,
Top 100 All Time
,
Top Voted Members
Hot Threads This Week
September 2026 Google Search Observations
AdSense Earnings and Observations - September 2026
An old fashioned desktop WYSIWIG HTML editor
Home
Forums Index
Server Side
/
Databases
12:25 pm Sep 21, 2026