SQL CASE - Overview, syntax

          

SQL CASE - Overview, syntax


SQL CASE statement - Introduction and syntax

<<Previous  Next>>

The answers to following questions will be made available soon. Keep visiting.

Explain the SQL CASE statement. Write SQL syntax for the SQL CASE statement along with an example.


SQL GROUP BY

GROUP BY: It is used with aggregate functions to group the result-set by one or more columns................  

SQL LIKE

LIKE clause is used for pattern matching. % is used to match any string of any length where as _ allows you to match on a single character................

SQL NOT NULL

SQL NOT NULL: The NOT NULL constraint enforces a column to NOT accept NULL values..............   

SQL SELECT INTO

SQL SELECT INTO: The SELECT INTO statement selects data from one table and inserts it into a different table. Used often for creating back up’s............

<<Previous  Next>>



Write your comment - Share Knowledge and Experience


 
Latest placement tests
Latest links
 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring