SQL Aggregate Functions

(Image by - Sharma Guides | Subham232330)

Aggregate Functions:- These functions are used to perform the calculations on data.

-> Returns a single value.

Types of SQL Aggregation Function

Aggregation Function

| - COUNT

| - SUM

| - AVG

| - MAX

| - MIN

Count() = Return the number of rows.

Sum() = It takes all values from different rows and returns their sum value.

Avg() = This function accepts values from multiple rows and returns an average of all values.

Max() = It returns the largest value.

Min() = It returns the smallest value.

Comments

Authentication vs Authorization

Authentication vs Authorization - Authentication and authorization are the two words used in the security world. They might sound similar but are completely different from each other. Authentication is used to authenticate someone's identity, whereas authorization is a way to provide permission to someone to access a particular resource. These are the two basic security terms and hence need to be understood thoroughly. In this topic, we will discuss what authentication and authorization are and how they are differentiated from each other. What is Authentication? Authentication is the process of identifying someone's identity by assuring that the person is the same as what he is claiming for. It is used by both server and client. The server uses authentication when someone wants to access the information, and the server needs to know who is accessing the information. The client uses it when he wants to know that it is the same server that it claims to be. The authentication by t...

SQL Constraints, NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, DEFAULT, CREATE INDEX

SQL Constraints (Image by - Sharma Guides | Subham232330) Constraints | |- CHECK | |- NOT NULL | |- UNIQUE | |- PRIMARY KEY | |- DEFAULT | |- FOREIGN KEY | |- INDEX * These constraints are also known as Integrity Constraints . * SQL Constraints:- Constraints are the rules and restrictions applied to the data in a table. * NOT NULL:- Value cannot be Null in a column. * UNIQUE:- Value cannot be the same in a column. * PRIMARY KEY:- Used to uniquely identify a row. * FOREIGN KEY:- References a row in another table. * CHECK:- Satisfies a specific condition. * DEFAULT:- Set default value. * CREATE INDEX:- Used to speed up the reading process.

Control Key Shortcuts

Control Key Shortcuts (Image by - Sharma Guides | Subham232330) CTRL+A = All Select CTRL+B = Bold CTRL+C = Copy CTRL+D = Duplicate CTRL+E = Alignment Center Side CTRL+F = Find CTRL+G = Group & Go To CTRL+H = Replace CTRL+I = Italic CTRL+J = Justify CTRL+K = Hyperlink CTRL+L = Alignment Left Side CTRL+M = New Slide CTRL+N = New Document & Page CTRL+O = Open CTRL+P = Print CTRL+Q = Quit CTRL+R = Alignment Right Side CTRL+S = Save CTRL+T = New Tab CTRL+U = Underline CTRL+V = Paste CTRL+W = Close The Window CTRL+X = Cut CTRL+Y = Redo CTRL+Z = Undo CTRL+Esc = Windows Start Menu CTRL+Tab = Switch between open tabs in the browser or other tabbed programs. CTRL+Shift+Tab = Will go backwards (right to left). CTRL+Delete = Delete Next Word. CTRL+Backspace = Delete Previous Word. CTRL+PgDn = Next Tab CTRL+PgUp = Previous Tab CTRL + ← = Previous Word CTRL + → = Next Word CTRL + Alt + ↑ = Rotate Screen Right Side C TRL + Alt + ↓ = Rotate Screen upsid...

Sharma Guides

Search This Blog