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
9:34 am May 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
,
Apr
,
Mar
,
Archive
,
Top 100 All Time
,
Top Voted Members
Hot Threads This Week
May 2026 Google Search Observations
AdSense Earnings and Observations - May 2026
AI visibility audit
Adsense / Personal Manager / Support
Hacker spoofing as GoogleBot
Page indexed but live url test gets 500 error
Link collaboration strategies
in case you missed it .
Microsoft, AS8075. Google, AS396982.
Bad actor claiming to be OpenAi
Home
Forums Index
Server Side
/
Databases
9:34 am May 21, 2026