- Using razorsql to get where a view retrieves data from iso#
- Using razorsql to get where a view retrieves data from download#
To learn more about SQL programming, Indiana University students, faculty, and staff can download materials for self-study from IT Training.įor the general public, various online tutorials are available, such as the w3schools.Stable version. '%en') in the example above, the result set might look like: If you used the % wild card instead (for example,.SELECT * FROM Friends WHERE First_Name LIKE '_en' To query the same table, retrieving all columns for rows in which the First_Name column's value begins with any letter and ends with "en", use this statement:.SELECT First_Name, Nickname FROM Friends WHERE Nickname LIKE '%brain%'
Nickname column contains the string "brain", use this statement:
The value is enclosed in single quotes (for example, WHERE last_name='Vader').
Using razorsql to get where a view retrieves data from iso#
SQL is an ANSI and ISO standard, and is the de facto standard database query language. Structured Query Language (SQL) is a specialized language for updating, deleting, and requesting information fromĭatabases.
SQL example statements for retrieving data from a table