Hi, I have a sql query problem... user points table, which I am sorting(order by) points. Now if I want to have some 5 records above and below a certain member, how could I write the sql query for the same? say I want 5 records above and below NICKNAME_14!
thanks and regards, point nickname ------------------ 999 NICKNAME_6 980 NICKNAME_23 970 NICKNAME_8 960 NICKNAME_9 940 NICKNAME_11 940 NICKNAME_41 932 NICKNAME_26 930 NICKNAME_12 930 NICKNAME_42 922 NICKNAME_38 920 NICKNAME_13 900 NICKNAME_2 900 NICKNAME_25 900 NICKNAME_5 ======================================================= 900 NICKNAME_14 ==================================================== 900 NICKNAME_3 880 NICKNAME_30 860 NICKNAME_57 860 NICKNAME_39 860 NICKNAME_21 859 NICKNAME_36 850 NICKNAME_20 840 NICKNAME_35 840 NICKNAME_19 836 NICKNAME_45 830 NICKNAME_33 830 NICKNAME_18 820 NICKNAME_17 810 NICKNAME_32 800 NICKNAME_24 800 NICKNAME_15 764 NICKNAME_54 700 NICKNAME_27 625 NICKNAME_59 600 NICKNAME_28 563 NICKNAME_55 500 NICKNAME_29 270 NICKNAME_49 270 NICKNAME_48 262 NICKNAME_56 260 NICKNAME_44 260 NICKNAME_51 260 NICKNAME_47 256 NICKNAME_50 250 NICKNAME_58 246 NICKNAME_43 226 NICKNAME_60 140 NICKNAME_53 ------------------------------------------------------------ Nishant <[EMAIL PROTECTED]> -------------------------------------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
