Your SQL works for me exactly as it is (substituting a table in my
database). What error are you getting?
On Wed, Nov 18, 2009 at 2:12 PM, Another Trad <anothertrad(at)gmail(dot)com> wrote:
> My question is quite simple: I want to select all the records from my table,
> but I want apply a LIMIT of 20% in the lines. like:
> select * from client limit 20%
> I have tried (of course, with no success) this:
> select * from client limit ((select count(*) from client)*20/100)
>
--
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center