How to show total sales?

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Umer Akram SSC-Insane Points: 22209 More actions · Answer 1

like i wanna display each pincodes how to make a code?

what do mean why above statement ?

SQLCJ SSCommitted Points: 1791 More actions · Answer 2

probably you are looking for something like this

select pincode,sales,SUM(sales) from #cust

group by pincode,sales with rollup

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 3

select 'Total '+convert(varchar(10),pincode) as [Total],sum(sales) [Sales]

from cust

--where pincode = 600004

group by convert(varchar(10),pincode)

Rgds

Igor Micev,My blog: www.igormicev.com

raghuldrag Hall of Fame Points: 3160 More actions · Answer 4

Hi ,

i m doing web application on google maps depends lat,long ll show marker on map

create table location

(

id int identity,

city varchar(20),

lattitude float,

lontitude float

descn

)

insert into locations values('chennai','13.062','80.641','Welcome to chennai')

so when i run my application its default show marker on chennai when i press the marker its open info window with "Welcome to chennai".

now my requirement is

each state i wanna show area wise (pincodes wise)marker in that description display the details of customer wise sales and total)

so how to make code ?

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 5

twin.devil (3/10/2014)
like i wanna display each pincodes how to make a code?
what do mean why above statement ?

Maybe this:

select pincode,SUM(sales) from cust

group by pincode

Igor Micev,My blog: www.igormicev.com

serg-52 SSCrazy Eights Points: 9913 More actions · Answer 6

If you need both subtotals and total see GROUP BY ROLLUP