am rather a newbie...but i was wonder what select statement i can use to retreieve the 10 top values from a table...for instance the 10 books that sell the most.... whit the largest numbers for noofsales
Select title, author, price, noofsales where noofsales between ????
if use between i need 2 values the MAX(noofsales) that would give me one value for the between..how do i find the 10 value?
or is there another select one could use?