1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

select inside select how do we do

Discussion in 'Databases' started by arunsuriindia, Mar 24, 2007.

0
  1. #1
    i have once done somthing like this i don`t remember how i did it

    table names

    fields names,city

    i want to display the name and how many times the name is there and to which city the name belongs to



    select name,select count(name) from names group by names,city, from names
     
    arunsuriindia, Mar 24, 2007 IP
  2. Alam

    Alam Active Member

    Messages:
    316
    Likes Received:
    91
    Best Answers:
    0
    Trophy Points:
    68
    #2
    Plz try

    select name,city, count(name) as total from names group by city;
     
    Alam, Mar 25, 2007 IP
  3. arunsuriindia

    arunsuriindia Peon

    Messages:
    61
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thanx for u r help it was nice to be under your guidance
     
    arunsuriindia, Mar 31, 2007 IP