Search In
<-- Chapter 16: SQL And & Or
Chapter 17
SQL ORDER BY
ORDER BY is the keyword used to sort the database table data by one or more columns. ORDER BY sort the Records in Ascending order by default. To sort the Record in Descending Order, we ha
<-- Chapter 9: SQL != Operator
Chapter 10
SQL LIKE 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
Soft
The SQL like clause is used to look for the values which are similar to the values in the table with the help of wildcard operators. We have two types of wildcard operators:
1. "%” - percent sign
2. “_”- underscore
Syntax:
SELECT FROM
NORMALIZATION
Database is a collection of meaningful data by which we can easily upload,update,delete and manage data.
while creating a database the main problem which encounter is data redundancy. Data redundancy is condition in which same piece o
SQL Server provides a number of global variables, which are very useful.The values of these variables is maintained by the server. All the global variables represent information specific to the server or a current user session.The names of global var
SQL CONSTRAINTS
A constraint is a rule or limitation that we place on the data in a database that we can put into a column(s). A constraint is part of the table. we can apply constraints when we create the table or afterwards. Constraints could be a
While performing joins you need specific columns of the joined tables so for doing that you need to mention the name of the column with their table name.
This task gets tedious because you have to write your table name with every column you
While working in SQL, you always write queries and stored procedures and these things needs to done in a better and go through the conventions manner so that the understandability of your script will be more.
Rules while writing queries in S
Waypoints API helps to find directions in Google. So how to pass multiple latitudes and longitudes in Waypoints API. This is the way pass a single lat long we would pass it as below
waypoints:
[{
location:new google.maps.LatLng(42.496403,-
While writing the stored procedure you always pass the parameters as the input type and the output type according to your need.
So while using these parameters you may notice that if you miss any parameter value during the stored pro
