SQL Server MAX
SQL Server MAX() function is an aggregate function that is used to find the Maximum or Largest value of a column .
Home » SQL SERVER »
SQL SERVER
SQL Server Tutorials| Basics & Advance Concepts | Interview Question & Answer Series | SQL Server Tricks & Tips
SQL Server MIN
SQL Server MIN() function is an aggregate function that is used to find the smallest or minimum value of a column
SQL COUNT
SQL Server COUNT() function is an aggreagate function that returns the number of rows in a table . It sets the number of rows or non NULL column values.
SQL Server SUM
SQL Server SUM function is an aggregate that returns the sum of values for any column in a table.
SQL FULL OUTER JOIN
SQL FULL JOIN or FULL OUTER JOIN returns rows from both left and right tables, with the matching rows from both tables where available. If there is no match, the missing side will have null values.
Displaying line numbers in Query Editor Window
we can enable line numbers to be displayed in Sql Server Query Editor Window.
SQL RIGHT JOIN
SQL RIGHT JOIN or RIGHT OUTER JOIN returns all rows from the right table and the matching rows from the left table.
SQL LEFT JOIN
SQL LEFT JOIN or LEFT OUTER JOIN returns all rows from the left table and the matching rows from the right table.
SQL Server JOINS
A JOIN clause is used to combine two or more related tables. Tables are related to each other using foreign key constraints.
SQL DATEPART()
SQL DATEPART() function is used to get a part of any specific date , it could be a day , month ,year or time of specific date.
SQL sp_help
SQL Sp_help is part of database engine stored procedures ,which returns information about a database object or a data type.
SQL DATEADD()
SQL DATEADD() function adds a number to a specified date part of an input date and returns the modified date.
SQL TRIM()
SQL Server TRIM() function is used to remove both Leading and Trailing spaces from any given string It was introduced in SQL Server 2017 version… Read More »SQL TRIM()
