Search In
<-- Chapter 15: SQL <= Operator
Chapter 16
SQL And & Or
AND/OR Operators are used in SQL statements to filter the Records based on more than one condition. AND Operator display the records in which all the specified conditions are TRUE.
<-- Chapter 13: SQL < Operator
Chapter 14
SQL >= Operator
Lets see an example from the below table "employees" :-
employee_id
name
code
designation
salary
101
ABC
E-101
Engineer
12000
102
DEF
E-102
Doctor
8000
103
GHI
E-103
<-- Chapter 23: SQL Wildcards
Chapter 24
SQL Aliases
SQL Aliases are used to rename a particular table name or column name in a temporary manner. In a SQL statement , any table or column name can be temporary change.
SQL Syntax for Columns :
<-- Chapter 24: SQL Aliases
Chapter 25
SQL Joins
SQL Joins clause are used to combine data rows from two or more than two tables according to common field values between them.
Lets see an examples from the below tables "customers" :-
<-- Chapter 25: SQL Join
Chapter 26
SQL Inner Join
SQL Inner Join clause is used to fetch all the rows from more than two tables in which there is a match between the columns. Inner Join is similar like Join clause.
Lets see an examples fr
Joins are used to combine the data from two tables and return specific rows of data from the tables.
A join can be either an inner join or an outer join, depending on what is expected in the result.
INNER JOIN:
Gets all matching rows in BOTH tab
Difference between datatype char(n),varchar(n),nchar(n),nvarchar(n) in sql server?
char(n)
A char datatype takes 1 byte per character. It is a fixed length character datatype i.e even though character entered are less than n,fixed memory size i.e n
SQL is Structure Query Language which is developed by E.F.Codd.Today almost all Relational Database Management Systems (RDBMS) uses SQL as the standard database language. We can use it to do different types of operations in RDBMS.
SQL COMMAND
SQL
In SQL while writing stored procedures sometimes you need variables for calculations and manipulations.
Variable we can use of two type
1 Local
2 Global
ALTER proc [dbo].[sp_CalculateRemainingLeaves]
(
@Employ
Quick sort in C programming is used to sort the elements of a list or an array either in ascending or in descending order.
Quick sort is based on the pivoting of the element and comparison and sorting is being made based on this element.
&n
