Author Archives: user

SQL – SORTING Results Table of content The SQL ORDER BY clause is used to sort the data in ascending or descending order, based on one or more columns. By default, some databases sort the query results in an ascending order. In addition to that, ORDER BY clause can also sort the data in a […]

SQL – UPDATE View Table of content SQL UPDATE View Statement A view is a database object that can contain rows (all or selected) from an existing table. It can be created from one or many tables which depends on the provided SQL query to create a view. Unlike CREATE VIEW and DROP VIEW there […]

SQL – DROP or DELETE View Table of content SQL allows you to drop an exiting view and delete records from a view in a database. SQL uses DROP statement to delete all the records from the view along with its definition and using the DELETE statement, only the records are deleted while the view […]