Logo 
Search:

SQL Interview FAQs

Submit Interview FAQ
Home » Interview FAQs » SQLRSS Feeds
SQL
Comments: 0

Using the CHECKS table, write a query to return all the unique remarks

Using the CHECKS table, write a query to return all the unique remarks.

SELECT DISTINCT REMARKS FROM CHECKS;
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

Which function capitalizes the first letter of a character string and makes the rest lowercase?

Capitalizes the first letter of a character string and makes the rest lowercase :

INITCAP
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

Which functions are also known by the name ?

Group functions and aggregate functions are the same thing.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

What SELECT COUNT(LASTNAME) FROM CHARACTERS; will return?

It will return the total of rows.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

Will SELECT SUM(LASTNAME) FROM CHARACTERS query work?

No, the query won't work because LASTNAME is a character field.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

Assuming that they are separate columns, which function(s) would splice together FIRSTNAME and

The CONCAT function and the || symbol.
Posted By:Shruti Sharma      Posted On: Dec 21

  1  2  3  4  5  6  7  8