Forum Sign UP Login Contact Us
HOME : Forum : SQL and Database : Post New Topic
Select query in mysql
krsmoorthi
11:22:11 04:28
i had 200 records in a table, i need to select only 5 records with interval as 50 ie. id as 1, 50, 100, 150, 200 but we can't use any loop condition or any temporary table. How we write single select query?
alok0077
04:15:12 03:09
select id from table_name where id=1,50,100,150,200;
Please Login to post your reply or start a new topic
Privacy Policy | Disclaimer
©2000 - 2014 plus2net.com All rights reserved worldwide