IwnfuM Posted December 17, 2010 Share Posted December 17, 2010 hey , just to know i need to express those words to MySQL syntax. 1.select last 10 from 'table'. 2.select last 10 from 'table' where id = '2'. thanks. Quote Link to comment Share on other sites More sharing options...
Maq Posted December 17, 2010 Share Posted December 17, 2010 Sounds like homework. 1.select last 10 from 'table'. Assuming you have a date column: ORDER by [date] DESC LIMIT 10; 2.select last 10 from 'table' where id = '2'. Same as the last query except the WHERE id = '2' condition. All if this syntax is in the MySQL manual. Next time read it so you can learn for yourself. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.