save up to 40%

What are the optional clauses used with the SELECT clause?

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 optional clauses used with the SELECT clause?

Rating:

The optional clauses used with the SELECT clause are as follows:

  • WHERE: It may be used to restrict the results that are returned by the query.

  • GROUP BY: It allows query results to be aggregated in terms of groups.

  • HAVING : It allows filtering over aggregated groups.

  • ORDER BY : It may be used to order the results that are returned by the query.


Rating:



Other articles

Click here to Article home

 
uCertify.com | Our Company | Articles | Privacy | Security | Contact Us | News and Press Release | uCertify India
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 CIW foundation    EC-212-32    CISSP    Photoshop ACE    Adobe Flash ACE
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.