What is SQL Injection?

SQL Injection is a type of injection attack. An attacker can use it to make a…

SQL Constraints

SQL Constraints are set of rules applied to a SQL tables to validate data. The purpose…

What is a View in sql server and its advantages ?

  A view is nothing more than a saved query.  A view can also be considered…

How to find Nth highest salary in Sql Server ?

How to find Nth highest salary in Sql Server ? Finding the first or second or…

What are the main differences between DML vs DDL?

The main difference between DML vs DDL is – one for managing data in database and…

Joins in SQL

SQL JOINS Joins in SQL are used to get related data from different tables. SQL joins…

What is the use of common table expression (CTE) in Sql Server?

CTEs are used to make the query easier. Whenever there are too many joins are being…

What is the use of “DISTINCT” in Sql Server?

“DISTINCT” keyword is used to remove the duplicate values in a given column. Example SELECT DISTINCT…

what is order by vs group by in sql server ?

Both order by and group by are used to organize data according to user needs. ORDER…

LOCAL AND GLOBAL TEMP TABLE

WHAT IS DIFFERENCE BETWEEN LOCAL AND GLOBAL TEMP TABLE? LOCAL TEMP TABLE Local temp table visible…