Display unique building names from LOCATION table.

Write queries/statements for the following. (Use tables created in Chapter 4 Lab Activity.)


```
SQL> SELECT DISTINCT BUILDING
2 FROM LOCATION;

BUILDIN
-------
Gandhi
Kennedy
Nehru
```

Computer Science & Information Technology

You might also like to view...

Which file name will end in a .h?

a. Implementation b. Application c. All input files d. Interface File e. A and B

Computer Science & Information Technology

The value of (#1/1/2017#).ToString("D") is

(A) 01/01/2017 (B) January 1, 2017 (C) January 01, 2017 (D) Sunday, January 1, 2017

Computer Science & Information Technology

Write a SELECT statement to list first and last names of all instructors sorted by last name. (10 rows)

What will be an ideal response?

Computer Science & Information Technology

The Navigation ________ makes it easy for you to move through records in a table

A) file B) bar C) Pane D) window

Computer Science & Information Technology