Like Class in SQL

Like Class in SQL The SQL LIKE clause is used to compare a value to similar values using wildcard operators. There are two wildcards used in conjunction with the LIKE operator: i.The percent sign (%) ii. The underscore (_) The percent sign represents zero, one, or multiple characters. The underscore represents a single number or […]

SQL Statements

SQL Statements 1.SQL INSERT Statement The INSERT Statement is used to add new rows of data to a table. We can insert data to a table in two ways, 1) Inserting the data directly to a table. Syntax for SQL INSERT is: INSERT INTO TABLE_NAME [ (col1, col2, col3,…colN)] VALUES (value1, value2, value3,…valueN); col1, col2,…colN […]

SQL Functions

SQL Functions SQL has many built-in functions for performing processing on string or numeric data. Following is the list of all useful SQL built-in functions: String functions: 1.ASCII: It Returns the ASCII code value of the leftmost character of a character expression. Syntax:ASCII ( character_expression ) Arguments character_expression: Is an expression of the type char […]

SQL VIEWS

SQL VIEWS Introduction: A VIEW is a virtual table, through which a selective portion of the data from one or more tables can be seen. Views do not contain data of their own. They are used to restrict access to the database or to hide data complexity. A view is stored as a SELECT statement […]

SQL Joins

SQL Joins Introduction: Sql joins are used to fetch or retrieve data from two or more data tables, based on a join condition. A join condition is a relationship among some columns in the data tables that take part in Sql join. Basically data tables are related to each other with keys. We use these […]

SQL Queries and Sub Queries

SQL Queries and Sub Queries SQL Queries: The SQL queries are the most common and essential SQL operations. Via an SQL query, one can search the database for the information needed. SQL queries are executed with the “SELECT” statement. An SQL query can be more specific, with the help of several clauses like FROM – […]

SQL Data Types

SQL Data Types Selecting appropriate data types is one of the most important considerations when designing a SQL Server database. Choices you make in the database design phase may have a significant impact on the efficiency, performance and storage requirements of your database. SQL data type is an attribute that specifies type of data of […]

SQL Operators

SQL Operators An operator is a reserved word or a character used primarily in an SQL statement’s WHERE clause to perform operation(s), such as comparisons and arithmetic operations. Operators are used to specify conditions in an SQL statement and to serve as conjunctions for multiple conditions in a statement. •    Arithmetic operators •    Comparison operators […]

SQL Guide

SQL Guide SQL Introduction Overview on Databases Data Definition Language (DDL) Data Manipulation Language (DML)   Data Control Language (DCL) SQL Data Types SQL Operators  SQL Functions  SQL Queries and Sub Queries SQL Queries  SQL Joins  SQL Views Normalization SQL InterviewQuestion -1 SQL InterviewQuestion -2  

SQL Queries

SQL Queries   SQL Expressions: An expression is a combination of one or more values, operators, and SQL functions that evaluate to a value. SQL EXPRESSIONs are like formulas and they are written in query language. You can also use them to query the database for specific set of data. Syntax: Consider the basic syntax […]