View Single Post
  #1 (permalink)  
Old December 11th, 2005, 02:25 PM
noam noam is offline
Registered User
 
Join Date: Dec 2005
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default relative size query

hi
I want to buid a query that will show me the relative size of data in a table. for example i have a table with names and age:

noam : 27
david : 34
gili : 24
shelly 34

the query should give me :
david : 1
shelly : 1
noam : 2
gili : 3

i think it needs a subquery on the select field but i dont know ...
thanks noam ..

Reply With Quote