SQL Statement for Retrieving Data
Not what you're looking for?
Please provide the answer in the order that need to run the script without an error.
Using the Northwind database, write a SQL SELECT statement that will retrieve the data for the following questions:
** Please refer to attachment for the full question description **
Purchase this Solution
Solution Summary
This solution shows how to run a script without an error.
Solution Preview
** Please see the attachment for a complete solution **
Thanks
--10 SQL Statements
--Details: Using the Northwind database, write a SQL SELECT statement that will retrieve the data for the following questions:
USE [Northwind]
GO
--1. Display the character constant 'Greeting' with a column heading of 'Hello.'
SELECT 'Greeting' AS 'Hello.'
GO
--o 1 row returned.
--2. Display all data from the categories tables without specifying the names of the table columns. Order the results by CategoryName.
SELECT *
FROM dbo.Categories
ORDER BY CategoryName
GO
--o 8 rows returned.
--3. Display all employees' names, last name first, and then first name, hire date and home phone number. Order the results by employee name,
---last name first, and then first name.
SELECT [FirstName]
,[LastName]
,[HireDate]
,[HomePhone]
FROM [dbo].[Employees]
ORDER BY [LastName] ,[FirstName]
GO
--o 9 rows returned.
--4. Modify query 3 so that the ...
Purchase this Solution
Free BrainMass Quizzes
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
C# variables and classes
This quiz contains questions about C# classes and variables.