Home » SQL & PL/SQL » SQL & PL/SQL » max
max [message #1405] Fri, 26 April 2002 08:12 Go to next message
Sarena
Messages: 1
Registered: April 2002
Junior Member
SELECT MAX ref_no
FROM Reservations
WHERE hotel_ID = 1;

could you tell me what's wrong with this query.
cheers
Re: max [message #1407 is a reply to message #1405] Fri, 26 April 2002 08:25 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
SELECT MAX(ref_no)
FROM Reservations
WHERE hotel_ID = 1;
Previous Topic: View with column select
Next Topic: Re: HOW TO CONVERT NUMBER TO WORD FORMAT WHERE NUMBER HAVING MORE THEN 5373484
Goto Forum:
  


Current Time: Thu Mar 28 19:39:55 CDT 2024