Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Query

This is a discussion on Query within the SQL forums, part of the Databases category; What will be the query for this: I have to find the total count of a particular customer ID occuring in a ,say, Sales Table...

Geeks Talk > Databases > SQL Query

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   05-25-2007

K.K.Rajiv Junior Member   Join Date: Apr 2007 Posts: 28 Thanks: 0 Thanked 5 Times in 4 Posts

Query What will be the query for this: I have to find the total count of a particular customer ID occuring in a ,say, Sales Table

The Following 2 Users Say Thank You to K.K.Rajiv For This Useful Post:

dhanasweet, vijayaramk.apps

Sponsored Links

#2 (permalink)   05-28-2007

jamesravid Expert Member   Join Date: Jun 2006 Location: India Posts: 411 Thanks: 15 Thanked 33 Times in 25 Posts

Re: Query it is quite simple, select cust_id, count(*) from supp group by cust_id; the above query displays each cust_id along with number of records in supp table for that custormer id __________________ Cheers, :) James:)

#3 (permalink)   05-29-2007

live2learn Junior Member   Join Date: May 2007 Posts: 3 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Query The above solution gives the count of all customers with the same id....so select cust_id, count(*) from supp WHERE cust_id = <> group by cust_id;

Geeks Talk > Databases > SQL

« API/Interface for implementing MRC | How can I display the records in specific format »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Query	jescalante	Oracle	4	06-25-2007 03:13 AM
Query with C++	StephenRaj	C and C++	1	08-14-2006 05:09 AM
Query in ASP	timmy	ASP.NET	1	07-26-2006 04:57 PM
Query on Size	scott	SQL	0	07-26-2006 04:33 PM
Query with SQL Leading Zero	timmy	SQL	2	07-17-2006 05:32 PM

All times are GMT -4. The time now is 01:13 PM.