What is the default sort order using ORDER BY? How can it be changed?
The default sort order is ascending. This can be changed by specifying the word DESC after any
column name in the ORDER BY clause. The word ASC can be used instead to specify ascending order.

Can you sort a column using a column alias?
Yes, you can sort by column aliases in an ORDER BY clause.

What is the difference between RANK and DENSE_RANK?
The difference between RANK and DENSE_RANK is where there is a tie or two records with the same
value.
RANK will assign non-consecutive values, which means there will be gaps in numbers.
DENSE_RANK will assign consecutive values, which means there will be no gaps.

What’s the difference between UNION and JOIN?
A join allows us to lookup data from one table in another table based on common fields (for example
employees and departments). It requires us to have a field that is common in both tables.
A union allows us to combine the results of two queries into a single result. No join between the results
is needed. Only the number and type of columns need to be the same.

What’s the difference between UNION, MINUS, and INTERSECT?
They are all set operators.
But, UNION will combine the results from query1 with query2 and remove duplicate records.
MINUS will display the results of query1 and remove those that match any records from query2.

INTERSECT will display the records that appear in both query1 and query2.

ACT Fibernet Atria Convergence Technologies
https://maps.app.goo.gl/Jc2LBbkxTw4hXkVS8

Cglia solutions LLp
Road no: 27 jubilee hills
Near MCR hrd inst
Hyderabad 500 033

17°26'19.2"N 78°24'27.3"E

NAMED FUNCTION SYNTAX (DEFINITION AND EXECUTION

Parameterized function (named function)

Spread operator ( operations) default value for spread operator [empty array ]

Limitation of spread operator

We can only pass 1 spread operator in a function

Only one spread operator is allowed and that must be the last function ( or occurrence)

Default function
Undefined is weaker and can't replace original values
Null is stronger and can delete original values

Returning in JAVASCRIPT ES6