SELECT {*|<Col1>}, <Col2>, <Col3>…
FROM <table name>
WHERE <column name> BETWEEN <lowest values> AND <highest value>
SELECT {*|<Col1>}, <Col2>, <Col3>…
FROM <table name>
WHERE <column name> LIKE [ALL | ANY] ‘[% | _] character string [% | _]’
To use of LIKE operator effectively, you have to provide the right pattern to it and never forget to use the ‘single’ quotes. One good thing about the LIKE operator in Teradata SQL is that we can pass multiple values (pattern) for our search using ALL or ANY operator, which I do not think is present in any other database environment. Here is any example;
SELECT First_Name, Last_Name
FROM employee
WHERE Last_Name LIKE ANY (‘%Sim%’,’ %Pet%’)
The above would return rows if either of the matching pattern found
SELECT First_Name, Last_Name
FROM employee
WHERE Last_Name LIKE ALL (‘%Sim%’,’ %Pet%’)
The above would return rows only if all of the matching pattern found. If you have an underscore present in your data value and you want that to come in your result set than you have to the escape operator to include the underscore as a value and not as a wildcard character. Here is the way
SELECT First_Name, Last_Name
FROM employee
WHERE Last_Name LIKE (‘%S\_%’) ESCAPE ‘\’
The above query would find results like S_123, S_mon, s_TUE, s_533T etc. Note that the underscore is present at the 2nd position of the string.
Our Random Articles
- Somdev Devvarman ousts Xavier Malisse 6-1, 3-6,7-6(5)
- How To Choose A Good Online Traffic School
- New Year Wishes 2010
- New Year Wishes
- How to use EXTRACT function with date and time columns
More Links




4 Comments
Material that you are providing is very easy to learn. But it is much better than this , if you ll give the full material of this at ONE LINK.
Thank you
Suresh.
That is right Suresh. This is the reason I have given all the links in one page, please visit this
http://readvitamin.com/teradata/
Hope this helps.
Hi. Can anyone tell me how to extract time from timestamp?
For Example
timestamp=’2008-03-28 14:11:04′
i want time ’14:11:04′ from timestamp through query.
Thanks in advance.
Hi Vaideesh,
If you need only time, you can probably try the following;
SELECT time;
To answer your question you should do something like this.
SELECT CAST(VaideeshTime as time(0)) from timestamp;
VaideeshTime
——–
14:11:04
Hope that helps.