troubleshooting Question

Return one row in a subquery

Avatar of Coco Beans
Coco Beans asked on
SQL
19 Comments4 Solutions88 ViewsLast Modified:
Hi,

I have a subquery but it's returning more than 1 row.  I only want the latest date available.

See below AND DATE = MAX DATE ONLY)

can anyone help?

Thank you

select st.student_id
  from (select student_id
          from registrations
         where registered = 'Y' AND DATE = MAX DATE ONLY) reg,
       students st
 where st = reg.student_id(+)
ASKER CERTIFIED SOLUTION
Coco BeansDesigner

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

Join our community to see this answer!
Unlock 4 Answers and 19 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 4 Answers and 19 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