mysql:
select g.* from (select @rownum:=0) r join ads g where (@rownum:=@rownum+1)<=(select round(count(*)*0.25) from ads);
sql server:
select top 25 percent * from student;
mysql:
select g.* from (select @rownum:=0) r join ads g where (@rownum:=@rownum+1)<=(select round(count(*)*0.25) from ads);
sql server:
select top 25 percent * from student;