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