What are the capabilities of a SELECT statement?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What are the capabilities of a SELECT statement?

Rating:

Following are the capabilities of a SELECT statement:

  • Projection: This capability is used to choose the columns of a table, which a user wants a SELECT statement to return.

  • Selection: This capability is used to choose the rows of a table, which a user wants a SELECT statement to return.

  • Joining: This capability is used to retrieve data from multiple tables by creating a link between them.


    • Rating:



    Other articles

    Click here to Article home

    MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD Cisco Certification: CCNA, CCENT, A+, Network+, Security+

    Oracle Certification: OCP 9i, OCP 10g, OCA 9i, OCA 10g, 1Z0-040: Upgrade to OCA 10g Fundamentals I, Oracle Fundamentals II, Admin I, Oracle Admin II, PL/SQL CIW foundation    Photoshop ACE
    © 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.
     
    HACKER SAFE certified sites prevent over 99.9% of hacker crime.