Select command

[David Barnett]

Try:

Select top 1 * from myTable order by pkey desc

David


David Barnett                 David at FairLibertysCall.com
C: 516-398-8668               www.FairLibertysCall.com

On Dec 30, 2013, at 5:27 PM, Jonathan Rumbold wrote:

> Hi Brian,
> 
> Is SELECT LAST a regular sql command? I use something like this:
> 
> SELECT * 
> FROM mytable
> WHERE pkey = (SELECT MAX(pkey) FROM mytable)
> 
> 
> Jonathan Rumbold
> 
> Omni Potent Solutions P/L
> 1537 Ghin Ghin Rd,
> Highlands Victoria 3660, Australia.
> 03 5796 9344
> 0408 969399
> 
> 
> 
> 
> -----Original Message-----
> From: omnisdev-en-bounces at lists.omnis-dev.com
> [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of
> brian at revolution911.com
> Sent: Tuesday, 31 December 2013 9:10 AM
> To: OmnisDev List - English
> Subject: Select command
> 
> Can the SELECT LAST command be used with Studio?  I can't seem to find the
> right variation of it or it's use in the list or manuals.
> 
> 
> 
> Thanks,
> 
> Brian
> 
> 
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com