[sqlite] Re: sqlite puzzle

[Igor Tandetnik]

JP <sqlamigo-/[EMAIL PROTECTED]> wrote:

SQLite provides a way to get the N-th row given a SQL statement, with
LIMIT 1 and OFFSET <N>.

Can the reverse be done in an efficient way?  For example, given a
table with 1million names, how can I return the row number for a
particular element?  i.e. something like

 SELECT rownum FROM
(SELECT name,<rownum> FROM clients
WHERE name='foo' ORDER BY name)

select count(*) from clients where name < 'foo';

Igor Tandetnik