Procurement Process Procurement system or purchasing system allows organizations to automate the...
Author - shohal
What is Material Management?
Material Management Materials management is a very common term used in manufacturing. It is the...
What is CTE (Common Table Expression) in SQL Server?
CTE (Common Table Expression) Common Table Expression, also called as CTE in short form, is a...
Character-Manipulative Functions
Character-Manipulative Functions Character-Manipulative Functions (CONCAT, LENGTH, SUBSTR, INSTR...
Sorting by Multiple Columns
Sorting by Multiple Columns For example, to sort person by their first names in ascending order and...
Sorting by Column Aliase(āĻāĻĻā§āĻŽāĻ¨āĻžāĻŽ)
Sorting by Column Aliase(āĻāĻĻā§āĻŽāĻ¨āĻžāĻŽ) SQL aliases are used to give a table, or a column in a table, a...
Sorting Data Order By Clause in Oracle SQL
ORDER BY keyword is used to sort the result-set in ascending or descending order. ORDER BY Example...
Single Row Functions
Case-manipulation functions Lower, Upper and Initcap are the three Case-manipulation/ Case...
What is normalization in Sql Server
Normalization is the process of organizing data to minimize data redundant(āĻ āĻ¨āĻžāĻŦāĻļā§āĻ¯āĻ(data...
What is subquery in sql server?
A subquery is a query that is nested (āĻŦāĻžāĻ¸āĻž āĻŦāĻžāĻāĻ§ā§)inside a SELECT , INSERT , UPDATE , or DELETE...