Lines Matching +refs:org +refs:table
78 my ( $stmt, @bind ) = $sql->select( $table, \@fields, \%where, \@order, $limit, $offset );
140 =item select( $table, \@fields, $where, [ \@order, [ $rows, [ $offset ], [ $dialect ] ] ] )
157 my $table = $self->_table(shift);
166 # return $self->SUPER::select( $table, $fields, $where, $order ) unless $rows;
167 return SQL::Abstract->new->select( $table, $fields, $where, $order ) unless $rows;
170 my ( $sql, @bind ) = $self->SUPER::select( $table, $fields, $where );
470 # DB2 select * from table fetch first 10 rows only
471 # Informix select first 10 * from table
472 # Microsoft SQL Server and Access select top 10 * from table
473 # MySQL and PostgreSQL select * from table limit 10
474 # Oracle 8i select * from (select * from table) where rownum <= 10
833 SELECT field_list FROM $table X WHERE where_clause AND
835 SELECT COUNT(*) FROM $table WHERE $pk > X.$pk
865 my ( $pk, $table ) = $sql =~ /^\s*SELECT\s+(\w+),?.*\sFROM\s+([\w]+)/i;
868 #warn "table: $table";
875 $sql =~ s/FROM $table /FROM $table X /;
882 SELECT COUNT(*) FROM $table WHERE $pk > X.$pk
922 Using the same table and column names, the top 100 ids are given by:
965 Looks to be identical to C<Top>, e.g. C<SELECT FIRST 10 * FROM table>. Can
1127 L<http://rt.cpan.org/NoAuth/Bugs.html?Dist=SQL-Abstract-Limit>.
1209 # You can't apply "limit" to non-table fetches
1243 # You can't apply "limit" to non-table fetches like "select LAST_INSERT_ID"
1268 # You can't apply "limit" to non-table fetches like "select LAST_INSERT_ID"
1326 # You can't apply "limit" to non-table fetches like "select LAST_INSERT_ID"
1347 # You can't apply "limit" to non-table fetches like "select LAST_INSERT_ID"