Need Help on SQL Query for select statement

Expand Post »

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

Similar Threads

sql query problem with MS Access and C# in C#
how to delete duplicate record in a table by using SQL query in MS SQL
Hi,Need help on sql select statement structure in MS SQL
SQL Query - rarely issue in ASP.NET
C# VS 2005 - SQL Query Parameters to an ODBC DataSource in C#

newMeg

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

21 posts
since Jul 2006

Permalink

Jul 7th, 2006

Re: Need Help on SQL Query for select statement

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

Last edited by hollystyles; Jul 7th, 2006 at 8:36 am.

hollystyles

Reputation Points: 262

Solved Threads: 68

Veteran Poster

Offline

1,181 posts
since Feb 2005

Permalink

Jul 9th, 2006

Re: Need Help on SQL Query for select statement

Hi hollystyles,

thanx for the great help.It works.

newMeg

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

21 posts
since Jul 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Setting Roles and Users in MS SQL

Next Thread in MS SQL Forum Timeline: Help Editing Trigs, Stored Procs, and Fkeys

DaniWeb Message

Cancel Changes

User Name
Password