LIMIT BASED ON PERCENT - Mailing list pgsql-sql

From Another Trad
Subject LIMIT BASED ON PERCENT
Date
Msg-id af7271950911181112h574da17euf94d9640ec7680df@mail.gmail.com
Whole thread Raw
Responses Re: LIMIT BASED ON PERCENT  (Lee Hachadoorian <lee.hachadoorian@gmail.com>)
List pgsql-sql
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:<br />select * from client limit 20%<br />I have tried (of course, with no success) this:<br />select * from
clientlimit ((select count(*) from client)*20/100)<br /> 

pgsql-sql by date:

Previous
From: Another Trad
Date:
Subject: Re: need nelp with aggregate functions
Next
From: Lee Hachadoorian
Date:
Subject: Re: LIMIT BASED ON PERCENT