Forum PHP.pl

[SQL] pobierz, plaintext 
SELECT p1.*
FROM Student AS p1, Student AS p2
WHERE p1.imie=p2.imie AND p1.student_id!=p2.student_id
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
HAVING
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT nrnad, imie, relacja
FROM bliscy GROUP BY imie, nrnad, relacja
HAVING ((IMG:http://forum.php.pl/style_emoticons/default/questionmark.gif) (IMG:http://forum.php.pl/style_emoticons/default/questionmark.gif) )
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT nrnad , imie , nazwisko FROM bliscy GROUP BY imie , nrnad , relacja HAVING ( imie > 1 );
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
count(imie)>1
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT nrnad , bimie , relacja
FROM bliscy GROUP BY bimie , nrnad , relacja 
HAVING (count( bimie )>1);
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT nrnad , bimie , relacja , COUNT(*) AS c FROM bliscy GROUP BY bimie , nrnad , relacja HAVING ( c > 1 );
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT nrnad , bimie , relacja , COUNT(*) AS c 
FROM bliscy 
GROUP BY bimie , nrnad , relacja
HAVING ( c > 1 );
[SQL] pobierz, plaintext 

Cytat(Cokpit @ 8.08.2009, 13:26:33 )

[SQL] pobierz, plaintext 
SELECT nrnad , bimie , relacja , COUNT(*) AS c 
FROM bliscy 
GROUP BY bimie , nrnad , relacja
HAVING ( COUNT(*) > 1 );
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT     type, COUNT(*) AS Expr1
FROM         sys.objects
GROUP BY type
HAVING      (COUNT(*) > 1)
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
COUNT(*)
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
bimie
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
 
SELECT 
  *
FROM 
  Student
WHERE
  imie IN
  (
    SELECT
       imie
    FROM 
      Student
    GROUP BY
      imie
    HAVING (count(imie) > 1)
  )
 
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT NRNAD, BIMIE, RELACJA, PLEC, WIEK
FROM   Bliscy
WHERE  (BIMIE IN
		    (SELECT BIMIE
			FROM Bliscy
			GROUP BY BIMIE
			HAVING (COUNT(BIMIE) > 1)
			)
		);
[SQL] pobierz, plaintext