A wildcard character is used to replace any character(s) in a string. Wildcard operator are used with SQL Like operator . The link to SQL WHERE Clause in mentioned in the article. Like operator are used with SQL WHERE CLAUSE to search for a particular pattern mentioned in the table/column. SQL Wildcard operators—> [SQL Like …
A database is a systematic collection of data. Database systems are used to store, access, delete data. furthermore, it also systematically organize data in a database.This article briefly discuss about the use and importance of SELECT Query in SQL. Consider a cafeteria, which provides snacks and other eatable item to its customers. Traditionally, the snacks, …
SQL is a database language that has commands to create, manipulate etc the database. All the commands can be broadly classified into following categories: DDL Commands DML Commands DCL Commands TCL Commands DDL(Data Definition Language) Commands: Data Definition Language commands in SQL are used to define the database schema. These commands deal with description of …
SQL DDL,DML,DCL,TCL COMMANDS – Free SQL Tutorial Read More »
SQL Aggregate functions are described in this article. SQL functions are like average , sum , count , first last etc. SQL Aggregate functions Consider the following Student table with ID, Marks, Age,Name as columns. +—-+——-+—–+———–+ | Table Name – Student | +—-+——-+—–+———–+ | ID | MARKS | AGE | NAME | +—-+——-+—–+———–+ | 1 …
SQL Aggregate Functions – Free Tutorial and Online Training Read More »
In SQL, there are a lot of library functions used while working with Date in Databases. The given below are the list of SQL date functions along with examples. SQL Date Functions NOW(): NOW() function returns the current date and time of the system. Example: Query: Select NOW (); Result: 2018-14-21 15:08:05 CURDATE(): CURDATE() functions …
SQL Date Functions – Free Tutorial and Online Training Read More »