MySQL Forums
Forum List  »  Newbie

where clause
Posted by: Jim Sawyer
Date: April 02, 2017 12:53PM

I have a where clause as follows:

'Select * from Records where Patno = :nPatno order by RecDate, Related, Placekey'

That yields several hundred records. I need to limit it to the last 55 records yielded by the above clause. How can I modify it to do that?

Thank you,
Jim Sawyer

Options: ReplyQuote


Subject
Written By
Posted
where clause
April 02, 2017 12:53PM
April 02, 2017 01:06PM
April 02, 2017 03:17PM
April 02, 2017 03:54PM
April 02, 2017 04:34PM
April 02, 2017 06:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.