Lines Matching refs:clause
630 // the WHERE clause limits/specifies which rows in the table
651 Specifying a blank WHERE clause will result in the result set containing
654 Specifying a blank ORDERBY clause means that the datasource will return
660 clause will eventually cause a problem for your program. Databases can be
663 specific sequence, ask for it that way by providing an ORDERBY clause.
665 Using an ORDERBY clause can be a performance hit, as the database must
676 The FROM clause in this example is blanked, as we are not going to be
677 performing any table joins with this simple query. When the FROM clause
695 syntax problem in the WHERE clause that was specified. The exact SQL
1067 // Set the WHERE clause to limit the result set to return
1198 the rows that match the WHERE clause.
1203 the rows that match the WHERE clause.
1213 descending order, add DESC after the ORDER BY Title clause.