Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: Best Fit SQL query statement

Re: Best Fit SQL query statement

From
Rodrigo De León
Date:
On Aug 6, 3:57 am, Kiran <kumar.m.ki...@gmail.com> wrote:
> and if I query on 98456 the result must be 98456,
> However if I query on 98455 the result must be 9845
> and If I query 9849 the result must be 984

SELECT MAX(t1) FROM t1WHERE '9849' LIKE t1 || '%';