SQL VISUAL QUICKSTART GUIDE- P15:SQL (pronounced es-kyoo-el) is the standard programming language for creating, updating, and retrieving information that is stored in databases. With SQL, you can turn your ordinary questions (“Where do our customers live?”) into statements that your database system can understand (SELECT DISTINCT city, state FROM customers;) | Chapter 4 Range Filtering with BETWEEN Tips test_column can be an expression. The NOT that can precede BETWEEN is independent of the NOT that can precede test_column see the Tips in Matching Patterns with LIKE earlier in this chapter. Listing shows how to rewrite Listing with an exclusive range which doesn t include the 10 and endpoints. See Figure for the result. Specifying a character range requires some thought. Suppose you want to search for last names that begin with the letter F. The following clause won t work because it will retrieve someone whose last name is the letter G is the letter G not starts with the letter G WHERE last_name BETWEEN F AND G This next clause shows the correct way to specify the ending point in most cases WHERE last_name BETWEEN F AND Fz In older PostgreSQL versions DBMS . . convert the floating-point numbers in Listings and to DECIMAL see Converting Data Types with CASTO in Chapter 5. To run Listings and change the floating-point literals to CAST AS DECIMAL In Microsoft Access date literals omit the DATE keyword and surround the literal with characters instead of quotes. To run Listing change the dates in the WHERE clause to 2000-01-01 and 2000-12-31 . In Microsoft SQL Server and DB2 date literals omit the DATE keyword. To run Listing change the dates in the WHERE clause to 2000-01-01 and 2000-12-31 . In some DBMSs low_value can exceed high_value search your DBMS documentation for WHERE or BETWEEN. Listing List the titles priced between 10 and exclusive. See Figure for the result. Listing SELECT title_id price FROM titles WHERE price 10 AND price title_id price T04 T09 T12 Figure Result of Listing . 120 Retrieving Data from a Table List Filtering with in Use IN to determine whether a given value matches any value in a specified list. The IN condition s important characteristics are IN works with character strings numbers and .
