var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: hepl required in selecting rows between 20 to 30
i want to select records between 20 to 30
i used the first n row. The query is as follows
SELECT FIRST 30 user_id FROM a_user WHERE NOT EXISTS( SELECT FIRST 20 user_id FROM a_user)
but first is not supported in subquery.
so i userd temp table,the query is as follows
SELECT FIRST 30 * FROM a_user INTO temp first30;
SELECT FIRST 20 * FROM a_user INTO temp first20;
SELECT user_id FROM first30 WHERE NOT EXISTS ( SELECT user_id FROM first20)
but it does not work,message is same.
Please help me out what is the alternate way