Introduction ORDER BY clause is used in a SELECT statement to sort results either in ascending or descending order. By default ORDER BY sorts the data in ascending order. Use the keyword DESC to sort the data in descending order and the keyword ASC to sort in ascending order. OFFSET [...]
Introduction SQL SELECT statement is used to query or retrieve data from a table in the database. A query may retrieve information from specified columns or from all of the columns in the table. SQL commands are not case sensitive. Syntax General syntax of SELECT is SELECT column_list FROM table_name [...]
Introduction SQL is a language that enables you to work with a database. Using SQL, you can insert records, update records, and delete records. You can also create new database objects such as databases and tables. And you can drop (delete) them. SQL is not case sensitive. It is divided [...]
Introduction Database Normalization is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy(repetition) and undesirable characteristics like Insertion, Update and Deletion Anomalies. It is a multi-step process that puts data into tabular form, removing duplicated data from the [...]
Introduction Data is a collection of a distinct small unit of information. It can be used in a variety of forms like text, numbers, media, bytes, etc. A database is an organized collection of data, so that it can be easily accessed and managed. It can organize data into tables, [...]