This is used to give alias name to table or column while writing sql query
In a table, a column contains duplicate value, if you want to list all different value only, then which SQL clause is used?
To give a temporary name to a table, or a column in a table for more readability, what is used ?
What does below SQL statement describe?
SELECT CustomerName, Address + ‘, ‘ + City + ‘, ‘ + Country AS Address
Alias named Address column will be created and under this Address, City and Country will be printed as combined statement.B.
Alias named Address will be created for Country columnsC.
Alias named Address column will be created and under this all CustomerName, address, city and country will be printed as combined statementD.
All above options are wrong
Logical operators used in SQL are
AND, OR , NOTB.
&&, ||, !C.
None of the above
To specify the number of records to return, which keyword is used
To search for a specified pattern in a column
Which clause is used to combine rows from two or more tables based on a related column between them.
Which is called as a virtual table in SQL?