On 27 April 2018 at 15:51, Hegde, Deepakakumar (D.)
<[email protected]> wrote:
> Hi All,
>
> We have a requirement where in offset of the primary key ID is needed as per
> the sorted list.
.
.
.
> 1 AAA
> 3 BBB
> 5 CCC
> 4 WWW
> 2 ZZZ
>
> So position of ID 3 as per the sorted list of the NAME is 2.
sqlite> create table t( id integer primary key, data text );
sqlite> insert into t( data ) values('aaa'), ('zzz'), ('bbb'), ('www'), ('ccc');
sqlite>
sqlite> select count(*)+1 from t where data<(select data from t where id=3);
2
> Thanks and Regards
> Deepak
Rgds,
Simon
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
