MS SQL

Need Help on SQL Query for select statement

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Jul 2006

Posts: 21

Reputation: newMeg is an unknown quantity at this point

Solved Threads: 0

newMeg

Offline

Newbie Poster

Need Help on SQL Query for select statement

Jul 7th, 2006

Hi,I'm new to daniweb forum. I hope someone could help.

I have a table called Caller which has a field called Area. I need to select the value of the record in this field that repeats the most. For example

Area
Sel
KL
Sel
Sel
Pen
KL

which means i want the answer as Sel because Sel is the higest number that repeated in the Area Column which is three(3) times. KL repeated twice and Pen once. I want to be able to write an SQL statement that could do this.

Can someone help pls. I've tried max but it didnt work. Thank you

•

Join Date: Feb 2005

Posts: 1,181

Reputation: hollystyles will become famous soon enough

Solved Threads: 67

hollystyles hollystyles is offline

Offline

Veteran Poster

Re: Need Help on SQL Query for select statement

Jul 7th, 2006

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
SELECT top 1 
	area, countarea 
FROM(
 
	SELECT 
		area, count(area) countarea 
	FROM 
		callers 
	GROUP BY 
		area
 
	) areacount
 
 ORDER BY 
	countarea DESC
select top 1 
	area, countarea 
from(

	select 
		area, count(area) countarea 
	from 
		callers 
	group by 
		area

	) areacount
 
 order by 
	countarea desc