224771 Mysql query needed

I need someone to write me a MYSQL query for my database to do the following functionality.

I am using MYSQL 4.1.22-standard

Say I have the following table with 4 fields(a1, b1, c1, d1) and 6 records;

a1 b1 c1 d1

1000 a d A

5000 b e A

3000 c e B

7000 a e A

5000 a f A

7000 b f B

I want a customisable query that can do something like


COUNT(d1) AS NumOccurrences

from TABLE

Where a1<6000 AND a1> 3000 AND b1=a AND c1!=f


So that the end result is a count by unique instances of d1 but with queries that I can customise to my hearts content.

Kemahiran: Semua Boleh, MySQL

Lihat lagi: n query, a1, write query, query table, mysql query, mysql 4, HEARTS, desc, c1, write mysql, query query, order mysql, query content query, need 7000, mysql queries using, 5000 needed, count mysql, query database, mysql table count, mysql select, mysql records, content query count result, database queries mysql, count database records, query mysql

Tentang Majikan:
( 7 ulasan ) Sydney, Australia

ID Projek: #1971007

Dianugerahkan kepada:


As described in PMB.

$15 USD dalam 0 hari
(68 Ulasan)