O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using conditions in WHERE clauses

As we've mentioned, the previous examples in the chapter make use of equality conditions. That is, each column value must be equivalent to a given condition in order for the row to be returned. However, in these examples, the equality conditions given were only evaluated against string literals. Equality conditions can apply to numeric and date values as well as character strings.

Using equality conditions

The following screenshot demonstrates an example of an equality condition:

Using equality conditions

The statement in the previous screenshot could be stated as, 'Show me the website and number of hits for any sites with 72 hits'. It demonstrates ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required