lundi 30 mai 2016

Mysql question

Hello,

I searched the internet but i couldnt find any info. I need something like this:
My database has many entries lets say a sample data is :

id value success
1 1.45 1
1 1.80 1
1 1.70 1
2 2.40 2
2 3.20 1
2 2.50 1
3 1.60 1
3 1.30 1
3 1.20 1
4 1.40 2
4 1.90 2
4 1.60 1

first, to group by the id all entries
I can do this simply with
select * from tbllist group by id

Now , what i need is :

1) determine the grouped id whichs all the values for...

Mysql question

from B4X Community - Android, iOS, desktop, server and IoT programming tools http://ift.tt/22ut4yF
via IFTTT

Aucun commentaire:

Enregistrer un commentaire