# OK : Simple sysvar stuffselect _rowid, staff_id, first_name, last_name from staff \p\gselect _rowid, staff_id, uname from users where _rowid > 2 \p\gselect staff_id, uname from users where _rowid > 2 \p\gselect _rowid, staff_id, pay_date from pay where _rowid <= 8 and _rowid > 4\p\g# OK : Create a sequence or threecreate sequence on staff\p\gcreate sequence on contact step 2\p\gcreate sequence on pay step -3 value 300\p\g# OK : Sequence stuffselect _seq from staff\p\gselect _seq from staff\p\gselect _seq from staff\p\gselect _seq from contact\p\gselect _seq from contact\p\gselect _seq from contact\p\gselect _seq from pay\p\gselect _seq from pay\p\gselect _seq from pay\p\gselect _seq from pay\p\g# OK : Sequence recreationdrop sequence from pay\p\gcreate sequence on pay step 7 value 100 \p\gselect _seq from pay\p\gselect _seq from pay\p\gselect _seq from pay\p\g# ERR : Failed duplicate sequencecreate sequence on pay\p\gcreate sequence on staff step 5 value 17\p\g# OK : Selects using sys var as ident field (with and without index)select _rowid,staff_id, first_name, last_name from staff 	where staff_id > _rowid\p\gselect _rowid,staff_id, first_name, last_name from staff 	where staff_id = _rowid\p\g# OK : Selects with sysvar to sysvar comparisonsselect _seq, _rowid, staff_id, first_name, last_name from staff	where _rowid < _seq\p\g