union:- union command remove the duplicates and selects only distinct values by default UNION command must have the same number
Continue readingCategory: SQL
ACID properties in SQL (Atomicity, Consistency, Isolation, Durability)
ACID(Atomicity, Consistency, Isolation, Durability) Property is the most important part of the database. ACID stands for Atomicity, Consistency, Isolation and
Continue readingWhat is the differences between delete, drop and truncate ?
Delete:- Delete is a DML statement and We can use where clause with DELETE to filter & delete specific records.
Continue readingDifference Between Clustered and Non-clustered index
only one clustered index per table where as you can have more than one non clustered index per table cluster
Continue readingHow To Find and Remove Duplicate records in SQL ?
I have created a table and inserted some records in Table for understanding purposes. Creating New Table create table
Continue readingFind The 2nd or 3rd Or Nth Highest Salary In SQL
I have created a table and inserted some records in Table for understanding purposes. — Creating New Table create table
Continue reading