SQL Cricket Team Ranking Based on Points
Problem Statement A cricket tournament is played between multiple teams. Winning team gets +1 point Losing team gets –1 point We need to calculate total… Read More »SQL Cricket Team Ranking Based on Points
Home »
sql interview question
SQL Exercise – 1
Query: Write a query to find the name of each employee, their department name, their manager’s name, and the total budget of the projects their… Read More »SQL Exercise – 1
Display employees and their manger name in SQL
This is one of the most asked SQL interview Question that write a SQL Query to display Employees and Manager name of the employee. Let’s… Read More »Display employees and their manger name in SQL
Get Row Counts for all tables in SQL Server
Sometime you are required to validate the row counts for each tables in database. So getting a row counts for each tables either through using… Read More »Get Row Counts for all tables in SQL Server
Separate numbers, letters and special characters from string
How to find and separate the numbers, letters and special characters from string? Suppose you a column in table which contains a mix words which… Read More »Separate numbers, letters and special characters from string
Get a last access time for tables in SQL Server
How to get a last access time for tables in SQL Server ? To get the last time when table was accessed in SQL Server,… Read More »Get a last access time for tables in SQL Server
Cascading referential integrity in SQL Server
Cascading referential integrity constraints are foreign key constraints that is used to defines the action that SQL Server performs when a user try to delete or update a primary key value to which an existing foreign key points.
SQL Server LAST_VALUE function
SQL Server LAST_VALUE function is a Analytic function which returns the Last value in an ordered set of values.
Primary Key VS Composite Key?
A PRIMARY KEY constraint uniquely identifies each record in a table .
A COMPOSITE KEY is a combination of two or more columns in a table that can be used to uniquely identify each row in the table when the columns are combined uniqueness is guaranteed, but when it taken individually it does not guarantee uniqueness.