Thread: Query advice
View Single Post
  #10 (permalink)  
Old 07-01-09, 11:49
anacedent anacedent is offline
Registered User
  
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,407
Select datetime, A, B, C, D from schema.table where B IN (1,2,3, 4) and datetime=trunc(sysdate)-1
ORDER by B
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Reply With Quote