ja,, ja,, Perry, what up man,

well then let me rephrase the question,

I have an address table, name, address, city, state, zip
in the table I have about 70k rows

I was trying to create a SQL command that will return me
2 records per city for each of the cities on my table.
doing a index unique will give me one of each, but is there
a sql statement that will return me 2 records per each city?


hope that helps


>I'd have to agree that this question is difficult to understand
>
>PF
>
>>Hello guys,
>>
>>I have the following question
>>
>>I have a table of cities , about 17 cities, on SoCal,
>>and about 70k rows on the table
>>How do go about selecting 2 rows per city, using sQL
>>
>>tx
>>
>>mark oliva