| krsmoorthi 11:22:11 | 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-2012 | select id from table_name where id=1,50,100,150,200; |