The SQL ORDER BY keyword is used to sort the result-set in ascending or descending order. SQL ORDER BY Keyword The ORDER BY keyword is used to sorts the records by default it sorts in ascending order. To sort the records in descending order, use the DESC keyword. To sort the records in ascending order, […]
Code and Demo This tutorial will see how we can Easily Translate the Angular 12 App Using the library Angular 12 with ngx-translate The internationalization (i18n) library for Angular ngx-translate: It is an internationalization library for Angular. It will let you define translations for your content in different languages and you can switch languages easily. […]
The SQL AND, OR & NOT Operators can be combined with the WHERE clause and used. These operators are usually used if you have multiple conditions to be checked for filtering out the data. The SQL AND, OR and NOT Operators The AND and OR operators are used to filter records based on more than […]
The SQL WHERE Clause is used to filter out the records. This Query allows you to add a condition that will return a resultset with that matching condition. SQL WHERE Clause You can use the WHERE clause not only in SELECT statements but also you can use in UPDATE, DELETE, etc. Syntax SELECT column_1, column_2 […]
The SQL data types are divided into five categories and that five categories have multiple properties to define a value for a table field. SQL Data Types Character/String Data Types Numeric Data Types Date/Time Data Types Binary Data Types Miscellaneous Data Types Character/String Character/Strings are used to store strings like names, locations, etc., and even […]
The SQL Select Distinct Statement is also used to select the data from the database the difference here is it will return only distinct (different) values. SQL Select Distinct Statement Inside a database table, a column may contain duplicate values, and some time you want to list down the different (distinct) values. Example: The scenario […]
You can do it via regular expression: use the /g (“match globally”) modifier with a regular expression argument to replace if you are assigning a RegExp directly let a = “[email protected]”; a = a.replace(/xxxx-/g, “”); if you want to pass RegExp with some variable let a = “[email protected]”; const code = ‘xxxx’; const key = […]
The SQL Select Statement is used to select the data from the database. So the data Which are returned is stored in the result table which is called a result-set. SQL Select Statement You can select the columns in multiple ways for example if you want all the columns of the particular table, you can […]
SQL Complete Guide In this course, we will cover all the syntax and queries of a relational database i.e SQL database. Our SQL course will make you learn and understand how can you use SQL in MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems. Topics Introduction to SQL Data Types […]