Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
problem getting n last items
thank you very much :) it works great --------------------------- http://www.infolibo.com/bci -
problem getting n last items
hi, i'm working with sql server 7 and i have a table like this: --------------------- id date section 1 1/1/2001 2 2 2/2/2002 3 etcetera --------------------- I need to get the 5 last items from every section, "last items" means order by date desc... I cannot find... -
how to get most repeated values from a field
thanks, Kevin! now it works fine! -
how to get most repeated values from a field
I need to select from a Mysql database the most repeated values from a field... I mean : --------------------- 22 22 5 1 1 1 --------------------- I need to get 1,22,5 in this order. Mysql does not allow joins. What sql command should I use?
