Sedang Disiapkan

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

SELECT *,

COUNT(d1) AS NumOccurrences

from TABLE

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

ORDER BY d1 DESC

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 lebih lanjut: 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:

brdless

As described in PMB.

$15 USD dalam 0 hari
(68 Ulasan)
5.9