Logo 
Search:

Interview FAQs

Submit Interview FAQ
Home » Interview FAQsRSS Feeds
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

Rewrite the query from exercise 1 so that the remarks will appear as the first column in query

Rewrite the query from exercise 1 so that the remarks will appear as the first column in your query results.

SELECT REMARKS, CHECK# FROM CHECKS;
Posted By:Shruti Sharma      Posted On: Dec 21

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

Using the CHECKS table from earlier today, write a query to return just the check numbers and t

Using the CHECKS table from earlier today, write a query to return just the check numbers and the remarks.

SELECT CHECK#, REMARKS FROM CHECKS;
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

Which of the following SQL statements will work?

a) select *
from checks;

b) select * from checks;

c) select * from checks


All the above work.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

Will below statements will work or not?

a.) Select *

The FROM clause is missing. The two mandatory components of a SELECT statement are the SELECT and FROM.


b.) Select * from checks

The semicolon, which identifies the end of a SQL statement, is missing.


c.) Select amount na...
Posted By:Shruti Sharma      Posted On: Dec 21

  10  11  12  13  14  15  16  17  18  19  20