top of page

Filtering and Concatenating in SQL


More basic notes on how to work in SQL, that I'm picking up as I go through Getting Started with SQL, an O'Reilly guide by Thomas Nield.

You can combine or concatenate fields using a double pipe || . You just enter field names in a table separated by the double pipes and use 'AS' to specify a new field to enter them in.

WHERE is used to filter data in SQL, as shown in this simple example.

This SQL query:

SELECT * FROM STATION_DATA

WHERE REPORT_CODE LIKE 'C%'

. . . will search the REPORT_CODE field for any entries which begin with the letter 'C'.

You can use <> or ! to filter for all entries except the specified string, or BETWEEN to search for values between two specified numbers.

SELECT * FROM STATION_DATA

WHERE YEAR BETWEEN 1980 AND 2000

Using IN before a set of values separated by commas in parentheses lets you search a specified group of values.

SELECT * FROM STATION_DATA

WHERE MONTH IN (10,11,12)

Parentheses can also be used to group Boolean queries in SQL.


Recent Posts

See All
NoSQL

NoSQL (not only SQL) or non-relational databases are increasingly being used by financial services businesses and businesses in other...

 
 

Sean O'Shea has more than 20 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

​

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.

​

If you have a question or comment about this blog, please make a submission using the form to the right. 

Your details were sent successfully!

© 2015 by Sean O'Shea . Proudly created with Wix.com

bottom of page