aku punya relasi query nih

SELECT judul_film,count(id_pinjam) from peminjaman_detail,film
where film.id_film=peminjaman_detail.id_film
group by peminjaman_detail.id_film 

hasilnya spt ini : judul_film-----------------count(id_pinjam) Da Vinci Code -----------------3 Red Eye-------------------------4 Flight Plan-----------------------5 Syriana--------------------------2 Inside man----------------------3 nah nilai maxnya khan 5 dng judul Flight Plan, gimana caranya biar aku bisa cari nilai max dari relasi tabel di atas misal: select max(....... from .... gimana nih para query expert...

kayaknya udah dijawab deh... ya pake max(count(id)) seperti itu.. select-nya dari query yg udah ada..

thanx broo

gini maksud nya deLogic.. :

SELECT judul_film,max(count(id_pinjam)) from peminjaman_detail,film
where film.id_film=peminjaman_detail.id_film
group by peminjaman_detail.id_film

hasilnya :

mysql kooar :Invalid use of group function

apa begini..

SELECT max(count(id_pinjam) from (select judul_film,(count(id_pinjam)) from peminjaman_detail,film
where film.id_film=peminjaman_detail.id_film
group by peminjaman_detail.id_film)

tapi malah tambah puanjan pesan kesalahannya :

You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'from (select judul_film,(count(id_pinjam)) from peminjaman_detail....

wah dibagi 2 aja om dibikin view dulu ben ga njlimet CREATE VIEW "VIEW_NAME" AS "SQL Statement" misal create view dulu namanya v_countpinjam

CREATE VIEW "v_countpinjam" AS SELECT judul_film,MAX(COUNT(id_pinjam)) AS count_pinjam FROM peminjaman_detail,film
WHERE film.id_film=peminjaman_detail.id_film
GROUP BY peminjaman_detail.id_film

abis gtu baru di select max

SELECT MAX(count_pinjam) FROM v_countpinjam

TMIIW ! :D [/code]

bisa juga di view nya pake:

CREATE VIEW "v_countpinjam" AS 
  SELECT judul_film, COUNT(id_pinjam) AS count_pinjam 
  FROM peminjaman_detail,film 
  WHERE film.id_film=peminjaman_detail.id_film 
  GROUP BY peminjaman_detail.id_film

trus dipanggil lewat

  SELECT judul_film, count_pinjam 
  FROM v_countpinjam 
  ORDER BY count_pinjam DESC
  LIMIT 0, 1

"limit 0, 1" membatasi result 1 record saja, yaitu record dengan jumlah terbanyak.

Ikutan ach .... Hmmm ... ngambil nilai MAX yach ... try this :

SELECT 
	MAX(COUTING)
FROM 
	(
		 SELECT
			film.judul_film,
			COUNT(peminjaman_detail.id_pinjam) AS COUTING
		FROM
			film, peminjaman_detail
		WHERE
			film.id_film = peminjaman_detail.id_film
		GROUP BY
			film.judul_film
	) Q1

database yang dipake apa dulu, mysql ato mssql nih...... biar jawabannya jd fokus.....:)

Kekekkek :lol: ...... mas imunk .... kayaknya pake Database MySQL dech .... soalnya dia nanya di thread MySQL ... ;)