On Sat, Jan 29, 2011 at 01:06:07PM -0800, Marian Cascaval wrote:
> On Sat, January 29, 2011, Nicolas Williams wrote:
> > If there's enough indices to satisfy all the ORDER BY expressions then
> > how could a "last()" function do any better? For that matter, if there
> > aren't enough indices to sa
On Sat, Jan 29, 2011 at 01:03:05PM -0800, Marian Cascaval wrote:
> Here's the info source on LAST() function:
>
> http://www.w3schools.com/sql/sql_func_last.asp
>
>
>
> I needed to retrieve the last row from a table.
If you need the "last row from a table" that's trivial to do efficiently
in S
dard.
Marian Cascaval
From: Puneet Kishor
To: General Discussion of SQLite Database
Sent: Sat, January 29, 2011 11:12:52 PM
Subject: Re: [sqlite] LAST() function not supported
On Saturday, January 29, 2011 at 3:03 PM, Marian Cascaval wrote:
> Here's
On Saturday, January 29, 2011 at 3:06 PM, Marian Cascaval wrote:
> As I see it,from the point of view of just retrieving the last row from a
> table,
> no ORDER BY is necessary thus saving processor time.
No, no, no, no. The db doesn't know what you mean by "last". If it happens to
give y
could do
SELECT OrderPrice FROM Orders ORDER BY DESC OrderDate LIMIT 1;
Hope this helps.
>
>
> From: Puneet Kishor
> To: General Discussion of SQLite Database
> Sent: Sat, January 29, 2011 10:47:44 PM
> Subject: Re: [sqlite] LAST() function not supported
: [sqlite] LAST() function not supported
On Sat, Jan 29, 2011 at 12:38:37PM -0800, Marian Cascaval wrote:
> Hi!
>
> Is LAST() function going to be supported?
>
> Or will the "SELECT ... FROM ... ORDER BY ... DESC LIMIT 1" workaround always
>be
>
> enough?
>
on of SQLite Database
Sent: Sat, January 29, 2011 10:47:44 PM
Subject: Re: [sqlite] LAST() function not supported
On Saturday, January 29, 2011 at 2:38 PM, Marian Cascaval wrote:
> Hi!
>
> Is LAST() function going to be supported?
>
> Or will the "SELECT ... FROM ...
On Sat, Jan 29, 2011 at 12:38:37PM -0800, Marian Cascaval wrote:
> Hi!
>
> Is LAST() function going to be supported?
>
> Or will the "SELECT ... FROM ... ORDER BY ... DESC LIMIT 1" workaround always
> be
> enough?
>
> My concern is if there might be any speed improvement if LAST() function wer
On Saturday, January 29, 2011 at 2:38 PM, Marian Cascaval wrote:
> Hi!
>
> Is LAST() function going to be supported?
>
> Or will the "SELECT ... FROM ... ORDER BY ... DESC LIMIT 1" workaround always
> be
> enough?
>
>
>
>
Where did you get information on this "LAST()" function?
> My
Hi!
Is LAST() function going to be supported?
Or will the "SELECT ... FROM ... ORDER BY ... DESC LIMIT 1" workaround always
be
enough?
My concern is if there might be any speed improvement if LAST() function were
to
be implemented, comparing to the workaround.
Marian Cascaval
__
10 matches
Mail list logo