| 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 |
