SQL Level

Which SQL keyword is used to extract data from a database?

In the database named "Company" we have table called "Customer", this table exists in the ops schema. Write a query to extract all data from the customer table

SELECT * FROM ops.Company.Customer;

SELECT ALL Customer IN dbo.Company;

WITH DBO { WITH {COMPANY} SELECT ALL

SELECT ALL FROM dbo.Company.Customer;

SELECT * FROM dbo.Company.Customer;

SELECT * FROM Customer;

One of these queries will work, pick the correct one

Version 1

Version 2

Version3

Version 4

The query "WITH Arr AS (SELECT 1 as Unit UNION SELECT 2 UNION SELECT NULL) SELECT 'TotalUnits' = SUM(Unit) FROM Arr WHERE Unit != NULL;" is not giving the correct results, what is wrong?

SQL Level

More Quizzes