Blog Tieng Viet How to get a specific number of entries per one key ?
Dec 03, 2011; 08:41
Blog Tieng Viet
How to get a specific number of entries per one key ?
Hellow everybody.=0A=0AI have a problem difficult for me, please give me an advice.=0A=0AI want to get a specific number of entry (rows) from a table =0Aby each Key. If the number is 1, I can use "select dinstinct",=0Abut the number is not 1, I don't know how to select.=0A=0AFor example:=0A=0AKey 0 | data 0-0=0AKey 0 | data 0-1=0AKey 0 | data 0-2=0AKey 1 | data 1-0=0AKey 1 | data 1-1=0A=0AI want to select 2 data for each key.=0AKey 0 (data 0-0, data 0-1), Key 1 (data 1-0, data 1-1).=0A=0AHow to describe in query ?=0A=0ABest regards.=0A=0A=0A--- On Sat, 12/3/11, Govinda <govinda.webdnatalk@gmail.com> wrote:=0A=0A> From: Govinda <govinda.webdnatalk@gmail.com>=0A> Subject: Re: delete syntax=0A> To: =0A> Cc: mysql@lists.mysql.com=0A> Date: Saturday, December 3, 2011, 6:43 AM=0A> >> =0A> >>> well, i am using delete/insert-statements=0A> since 10 years to maintain=0A> >>> users since you only have to know the tables=0A> in the database "mysql"=0A> >>> and use "flush privileges" after changes=0A> >>> =0A> >>> The privileges should be maintained only=0A> using the designated commands.=0A> >> You cannot rely on the knowledge you have of the=0A> underlying implementation=0A> >> which can change anytime , while the privileges=0A> command are standard.=0A> > =0A> > do what you think is good for you if YOU can't be sure=0A> what you do=0A> > [snip]=0A> > so please do not tell other peopole on what knowledge=0A> they can rely=0A> > =0A> =0A> =0A> *all* the back and forth in these threads is good.. is=0A> susses out all the knowledge for everyone to see.=0A> Sincerely thanks to everyone who chimes in from all=0A> perspectives,=0A> -Govinda=0A> --=0A> MySQL General Mailing List=0A> For list archives: http://lists.mysql.com/mysql=0A> To unsubscribe: http://lists.mysql.com/mysql=0A> =0A>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Dec 03
Arthur Fuller Re: How to get a specific number of entries per one key ?
Dec 03, 2011; 16:35
Arthur Fuller
Re: How to get a specific number of entries per one key ?
Dec 05
Rik Wasmus Re: How to get a specific number of entries per one key ?
Dec 05, 2011; 11:20
Rik Wasmus
Re: How to get a specific number of entries per one key ?
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!