Ask the Expert

Using the SELECT and WHERE clauses to display data

How can I display the results of 3 columns (A, B, C) in one table if the value of column "C" is greater than a specific number?

    Requires Free Membership to View

    Login

In this case, we specify the columns we want in the SELECT clause and narrow down the results in the WHERE clause:

SELECT A, B, C

FROM mytable

WHERE C > 50;

This was first published in May 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top