Forum Sign UP Login Contact Us
HOME : Forum : SQL and Database : Post New Topic
Select query in mysql
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?
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 - 2015 All rights reserved worldwide