Search In
The GROUP by statement is used with the aggregate functions to group the result by one or more columns.
GROUP by Syntax
SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP by column_name;
We h
In MySQL, The SELECT statement is used to select data from a table.
SELECT Syntax
SELECT column_name,column_name
FROM table_name;
and to select all records
SELECT * FROM table_name;
We have a table "employee" as below:
employee
id fi
In MySQL, aliases are used to give temporarily name to a table or a column. When we write a query we use Aliases to make column name more readable.
Alias Syntax for Columns
SELECT column_name AS alias_name
FROM table_name;
Alias Syntax for Tables
In MySQL, the BETWEEN operator is used to select values (values can be numbers, text, or dates) from a column within a specified range.
BETWEEN Syntax
SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;
We have a ta
Database Language Integrated Query or LINQ with Database is known as DLINQ.
Mainly used when we want to manipulate data from the database.
LINQ to SQL Statements
Data Context
The data context provides the mapping of all entities (essentia
Functional testing checks that every Function of the product/software application works in conformance with the requirement determination/specification. This testing mainly includes black box testing and it is not worried about the source code of the
XML data type was introduced in SQL Server to work with XML data.
Type of XML Data
AUTO
It generates output with both element and attribute features in combination with a sub query.
SELECT * from Employees
FOR XML AUTO;
EXPLICIT
Hello Friends,
Here we are going to discuss the prevention of sql injection problem in wordpress website. Suppose we have an option to search an user in our website now see what an unlawful user can do with this:
In search box an user can input lik
FULL OUTER JOIN
If you want to combine the results of both LEFT and RIGHT join than we use FULL JOIN keyword. The joined table which created after FULL JOIN contains all records from both the two tables, and fills null value for those places where
What is Keyword?
Keywords are very important to your Site’s SEO. For the entire SEO campaign your Keywords will act as the cornerstone. If you don’t have right keywords, you have no foundation for your SEO structure and you won’t get the desired res
