Interested to Buy Any Domain ? << Click Here >> for more details...
What does the following SQL statement return, assuming that
all tables and column names are correct?
SELECT FirstName, StreetAddress
FROM Employees
JOIN AddressBook
ON Employees.EmpID = AddressBook.EmpID
a) Nothing, the JOIN syntax is wrong.
b) All the records form the Employees table, and only the
matching ones form the StreetAddress table.
c) All the records from the StreetAddress table and only the
matching records form the Employees table.
d) Only the matching records from the two tables.
- 4 Answers
- 9185 Views
- Syntax Softtech, I also Faced
- E-Mail Answers
Answer Posted / karuna
option d
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Who generates session id?
How to unit test Web API?
Can you explain how ASP.NET application life cycle and page life cycle events fire?
What symbol specifies the beginning of a query string?
What is the difference between a candidate key and primary key?
What is s2s tracking?
How to fetch a data from one table to another table in asp.net ?
Differentiate between globalization and localization.
What is web api and why to use it?
What is view state and how it works in asp net?
What are the parts of an http response?
Describe the method to create a permanent cookie?
What is difference between viewstate and session in asp net?
What is http pipeline in asp.net?
What is connection pooling and how to enable and disable connection pooling?
