Sorting by Multiple Columns For example, to sort person by their first names in ascending order and...
Author - shohal
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...
What is The %ROWTYPE Attribute in PL/SQL?
The %ROWTYPE attribute provides a record type that represents a row in a database table. The record...
What is system trigger?
System Trigger fires when a system event like database startup, shutdown or DDL operations like...
What is in and in out Procedure Parameter in Pl/Sql?
How to pass parameters to Procedures and Functions in PL/SQL? In PL/SQL, we can pass parameters to...
SQL Interview Questions
SQL Interview Questions and Answers What is SQL? SQL stands for the Structured Query Language. It...