SQL Having

The HAVING was added to SQL because the WHERE keyword cannot be used with aggregate functions. Syntax:- SELECT column_name, aggregate_function(column_name) FROM table_name WHERE column_name operator value GROUP BY column_name HAVING … Continue reading “SQL Having”

February 28, 2016 webetutorial

SQL Ucase()

The UCASE() converts the value of a field to uppercase. Syntax:- SELECT UCASE(column_name) FROM table_name; Example:- The subsequent SQL selects the “VisitorName” and “City” columns from the “Visitors” table, and … Continue reading “SQL Ucase()”

February 28, 2016 webetutorial

SQL Lcase()

The LCASE() converts the value of a field to lowercase. Syntax:- SELECT LCASE(column_name) FROM table_name; Example:- The subsequent SQL selects the “VisitorName” and “City” columns from the “Visitors” table, and … Continue reading “SQL Lcase()”

February 28, 2016 webetutorial

SQL Mid()

The MID() is used to extract characters from a text field. Syntax:- SELECT MID(column_name,start,length) AS some_name FROM table_name; Example:- The subsequent SQL selects the first three characters from the “City” … Continue reading “SQL Mid()”

February 28, 2016 webetutorial

SQL Len()

The LEN() returns the length of the value in a text field. SQL LEN() Syntax:- SELECT LEN(column_name) FROM table_name; SQL LEN() Example:- The subsequent SQL selects the “VisitorName” and the … Continue reading “SQL Len()”

February 24, 2016 webetutorial

SQL Round()

The ROUND() is used to round a numeric to the number of decimals specified. SQL ROUND() Syntax:- SELECT ROUND(column_name,decimals) FROM table_name; SQL ROUND() Example:- The subsequent SQL selects the name … Continue reading “SQL Round()”

February 24, 2016 webetutorial

SQL Now()

The NOW() returns the current system date and time. SQL NOW() Syntax:- SELECT NOW() FROM table_name; SQL NOW() Example:- The subsequent SQL selects the name and age for today from … Continue reading “SQL Now()”

February 24, 2016 webetutorial

SQL Format()

The FORMAT() function is used to design how a field is to be displayed. SQL FORMAT() Syntax:- SELECT FORMAT(column_name,format) FROM table_name; SQL FORMAT() Example:- SELECT Name, age, FORMAT(Now(),’YYYY-MM-DD’) AS Date … Continue reading “SQL Format()”

February 24, 2016 webetutorial

SQL Alter Table

The SQL ALTER TABLE is used to add, delete or modify columns in an existing table. SQL Alter Table:- ALTER TABLE table_name ADD column_name datatype Drop Column:- ALTER TABLE table_name … Continue reading “SQL Alter Table”

February 24, 2016 webetutorial

HTML Character Sets

ASCII was the first character set. It describes 127 different alphanumeric characters that can be used on the internet.

February 18, 2016 HTML webetutorial

SQL Indexes

Indexes are extraordinary lookup tables that the database web crawler can use to accelerate information recovery. Basically, a list is a pointer to information in a table. An index speeds … Continue reading “SQL Indexes”

February 17, 2016 webetutorial

SQL Select Into

The SELECT INTO statement copies data from one table and inserts into a new table. Syntax:- SELECT * INTO newtable FROM table1; The new table contains the column-names and types … Continue reading “SQL Select Into”

February 17, 2016 webetutorial

SQL Unions

The SQL UNION is used to combine the results of two or more SELECT statements without any duplicate rows. To utilize UNION, each SELECT must have the same number of … Continue reading “SQL Unions”

February 17, 2016 webetutorial
X
Subscribe to our newsletter
Subscribe to our newsletter today to receive updates on the latest news and offers.
100% Privacy. No spam guaranteed
webe tutorial
Menu