Modified AT $ DATE: 2005/03/09 07:11:12 $
Can't Believe It Takes Me So Long to Do A So Easy Thing In SQL.
I have to do something to make myself the best. I forward So Much ... Luckily i Still Can Write Something. ^ _ ^.
A TO HELP HIM TO WRILDS IN A TABLE WANT TO SELECT FIELDS IN A TABLE WANT TO SELECT FIELDS IN A TABLE WANT TO SELECT FIELDS IN A TABLE IN The Field in The Same Table. Suppose
CLINICADDRESSCLINIC11213243546574
ONE CLINIC HAS MORE THAN ANDE CLINICADDRESS. How to do this in query analyzer.
SQL Query Is Below.
Select Clinic, Count (*) as countnumberfrom clinic_address group by clinichaving count (*)> 1ORDER BY CountNumber
Use Having Clause to make it it. Easy? But why i forward it ??? what a shame to me!
