troubleshooting Question

Query return only last three incidents

Avatar of ba_trainer
ba_trainer asked on
SQL
8 Comments1 Solution204 ViewsLast Modified:
The query below returns all the calls back to Jan 2008.
I need it to only return the last three calls.

Can anyone help?
Thanks!
Beth
SELECT cmplt_dt, enti_nbr
FROM sales_business_alignment, UI_RESULTS_DB.cibent, sales_datebook
 
WHERE enti_nbr = ent
AND cust_nbr = cust_acct_nbr
AND cust_acct_nbr IS NOT NULL
AND cmplt_dt >= '01/01/2008'
ASKER CERTIFIED SOLUTION
pcelba

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros