Oracle SQL (PL/SQL): SELECT COUNT(*) INTO cnt_var FROM TABLE1;
Sybase Transact-SQL: SELECT @cnt_var = COUNT(*) FROM TABLE1