What is the different between UNION and UNION ALL?
1. Union will combine two tables’ data without duplications
2. Union all will combines two tables’ data
3. Union all won’t remove duplications
4. If we are combining two tables columns sequence and data types should be same
5. Union returning data with new row
What is the different between UNION and JOIN?
1. Union will combine the two table’s data with new row
2. Join will combines the data with new Columns
What are the aggregate function?
MIN returns the smallest value in a given column
MAX returns the largest value in a given column
SUM returns the sum of the numeric values in a given column
AVG returns the average value of a given column
COUNT returns the total number of values in a given column
COUNT(*) returns the number of rows in a table
WHAT IS THE DIFFERENCE BETWEEN FIND VS SEARCH?
Find is case-sensitive.
Search is case-insensitive.
WHAT IS THE DIFFERENCE BETWEEN SUBSTITUTE VS REPLACE?
If you know the text to be replaced, use the SUBSTITUTE function.
If you know the position of the text to be replaced, use the REPLACE function.
WHAT IS RIGHT FUNCTION?
Returns the specified number of characters from the end of a text string.
WHAT IS LEFT FUNCTION?
Returns the specified number of characters from the start of a text string.
WHAT IS CLEAN FUNCTION?
Remove all not printable characters from text.
WHAT IS TRIM FUNCTION?
Remove all spaces from string except single space between words.
WHAT IS EXACT FUNCTION?
Check whether two strings are exactly same or not (TRUE or FALSE)
WHAT IS MATCH FUNCTION?
Its returns the relative position of an item in an array that matches a specified value in a specific order.
WHAT IS INDEX FUNCTION?
Returns value or reference of the cell at the intersections of rows and columns.
WHAT IS COUNT, COUNTA, COUNTIF, AND COUNTIFS FUNCTION?
Please Whitelist JSFiddle in your content blocker.
Help keep JSFiddle free for always by one of two ways:
Whitelist JSFiddle in your content blocker (two clicks)
Go PRO and get access to additional PRO features →
Join the 4+ million users, and keep the JSFiddle dream alive.
Ad-free
All ads in the editor and listing pages are turned completely off.
Use pre-released features
You get to try and use features (like the Palette Color Generator) months before everyone else.
Fiddle collections
Sort and categorize your Fiddles into multiple collections.
Private collections and fiddles
You can make as many Private Fiddles, and Private Collections as you wish!
Console
Debug your Fiddle with a minimal built-in JavaScript console.