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)
- [SQL] LIMIT BASED ON PERCENT Another Trad
- Re: [SQL] LIMIT BASED ON PERCENT Lee Hachadoorian
- Re: [SQL] LIMIT BASED ON PERCENT Another Trad
- Re: [SQL] LIMIT BASED ON PERCENT Guillaume Lelarge
- Re: [SQL] LIMIT BASED ON PERCENT Another Trad
- Re: [SQL] LIMIT BASED ON PERCENT Pavel Stehule
- Re: [SQL] LIMIT BASED ON PERCENT Pavel Stehule
- Re: [SQL] LIMIT BASED ON PERCENT Lee Hachadoorian
- Re: [SQL] LIMIT BASED ON PERCE... Pavel Stehule
- Re: [SQL] LIMIT BASED ON PERCENT Kris Kewley
- Re: [SQL] LIMIT BASED ON PERCENT Guillaume Lelarge