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
11:14 pm Jul 10, 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
,
Jun
,
May
,
Archive
,
Top 100 All Time
,
Top Voted Members
Hot Threads This Week
July 2026 Google Search Observations
AI = New incoming wave of unemployment?
AdSense Earnings and Observations - July 2026
Annoying Crawler, Bot, or what?
How Would Someone Lock Onto A PDF
What strategies work to produce AI share of access?
Structuring Performance-Based Digital PR For Link Building
Do anything special today?
June 2026 Google Search Observations
Home
Forums Index
Server Side
/
Databases
11:14 pm Jul 10, 2026