Soldato
- Joined
- 16 Dec 2003
- Posts
- 2,697
I'm stuck on my SQL at the moment, what I'm trying to do is to get the name of the pet that has visited the vets on the most occasions.
Here's the current query I've created at the moment:
SELECT petname AS "Pet name"
FROM pet
WHERE petid = (SELECT Max(count(visit.petid))
FROM visit
GROUP BY petid);
The problem in this query, the petID 6 shows up 4 times but it displays the name of petID 4, could someone please help me how can I display the name of the pet that has visited on most occasions please?
I'm using Oracle SQL*Plus if that helps
Here's the current query I've created at the moment:
SELECT petname AS "Pet name"
FROM pet
WHERE petid = (SELECT Max(count(visit.petid))
FROM visit
GROUP BY petid);
The problem in this query, the petID 6 shows up 4 times but it displays the name of petID 4, could someone please help me how can I display the name of the pet that has visited on most occasions please?
I'm using Oracle SQL*Plus if that helps
