Comments are hints that a programmer add to explain the statements and make it more understandable. It is also used...
Continue reading...Learn2Done
SQL SELECT DISTINCT
SELECT DISTINCT statement is used to fetch only the distinct (different) data from a table. Syntax: SELECT DISTINCT column1, column2...
Continue reading...C++ IDENTIFIERS Copy
Identifiers are fundamental building blocks of a program and are used as the general terminology for the names given to...
Continue reading...C++ JUMP STATEMENT
In C language there are 4 types of jump statements: Break Statement Continue Statement Goto Statement Return Statement Break Statement:...
Continue reading...C++ ENCAPSULATION
In general, encapsulation is a process of wrapping similar code in one place. In C++, we can bundle data members...
Continue reading...RANK() vs DENSE_RANK vs ROW_NUMBER
The function of count(*), count(1), count(‘a’) is same. That means that they all gives count of all the rows including...
Continue reading...Drop table vs Truncate vs Delete
Drop Table: This statement deletes the table from the database. Truncate: This statement deletes all the rows from the table...
Continue reading...What is the difference between count(*), count(1), count(‘a’), count(column_name)
The function of count(*), count(1), count(‘a’) is same. That means that they all gives count of all the rows including...
Continue reading...Write a query to find the second highest salary of each department
Data id name salary department 1 Gaurav 50200 Account 2 Pyush 10960 HR 3 Ram 70870 Secutity 4 Lakshaman 8600...
Continue reading...SQL SELF JOIN
The SELF JOIN joins the table with itself. Syntax: SELECT column_name(s) FROM table A, table B WHERE condition; Here A and B...
Continue reading...