AppDividend
Latest Code Tutorials
Browsing Category

SQL

SQL is a standard language for storing, manipulating and retrieving data in databases.

Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.

SQL Distinct: The Complete Guide

If you want to remove duplicate items from the final result set, then SQL Distinct is the answer to your problem. It filters out duplicate items and returns unique values from the table. The distinct keyword is used with the select…

SQL UPPER() Function: The Complete Guide

If you have an online shopping website. Customers visit the website and provide the necessary information while creating the login account. Each customer provides a few compulsory information such as first name, last name, phone number,…

SQL ASCII() Function: Introduction

SQL ASCII() function is used to return the numeric value of a character given as an input to the function. The ASCII() function acts opposite to that of the CHAR function. ASCII stands for American Standard Code for Information Interchange.…

SQL SPACE() Function: The Complete Guide

THE SQL SPACE() function is used to return a repeated sequence of space, i.e., a string with a specified number of spaces. SQL SPACE Function SQL SPACE() is a built-in function that returns the string of the specified number of space…

SQL LIKE Operator: Complete Guide

SQL LIKE Operator is used in the WHERE clause to search for the specified pattern in a column. There are two wildcards often used in conjunction with a LIKE operator: % - Percent sign represents zero, one, or multiple characters.…