dhagat.ani
BAN USER
Comments (6)
Reputation 10
Page:
1
Comment hidden because of low score. Click to expand.
Comment hidden because of low score. Click to expand.
0
of 0 vote
The CROSS JOIN is used to generate a paired combination of each row of the first table with each row of the second table. This join type is also known as Cartesian join.
A Natural Join joins two tables based on same column name and datatypes. The resulting table will contain all the columns of both the table but keep only one copy of each common column.
Comment hidden because of low score. Click to expand.
0
of 0 vote
A query within a query is known as a subquery. It's kind of a nested query.
- dhagat.ani January 25, 2022Comment hidden because of low score. Click to expand.
0
of 0 vote
1. Single Row Subquery
2. Multiple Row Subquery
3. Multiple Column Subquery
Comment hidden because of low score. Click to expand.
0
of 0 vote
SELECT COUNT(DISTINCT column_name) from table;
- dhagat.ani January 25, 2022Comment hidden because of low score. Click to expand.
1
of 1 vote
SELECT COUNT(column_name) from table;
- dhagat.ani January 25, 2022Page:
1
CareerCup is the world's biggest and best source for software engineering interview preparation. See all our resources.
A NULL Value means nothing at all. It's neither equal to a zero nor a blank space.
- dhagat.ani January 25, 2022