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
- 9056 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
Difference between DataGid and Girdview? Difference b/w .Net 2.0, 3.0 and 3.5 ? Diff b/w dispose & Finialize Methods?
Define what is razor? : asp.net mvc
What is the difference between union and join?
Explain file-based dependency and key-based dependency.
What do you mean by serialize?
Whta are the Various steps taken to optimize a web based application (caching, stored procedure etc.) ?
How to comment out asp.net tags?
Can we have 2 web config files?
What is a web server? What are the load limits in it?
Where is asp.net session stored?
How we can force all the validation controls to run?
What is http only cookie?
What websites use asp.net?
Define data caching?
In Data grid the question is below quantity price total these are 3 fields available in data grid if you enter quantity the total has to update automatically.Price field is already filled completely
