Buy Questpond's video subscriptions on
huge discount
.
Online: 1342
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
which one of the following is suitable for writing a new query that will return names from the employee table for people who are not part of the contractors table (the two tables share a unique id, similar to social security or NI number).
Posted by
Bandi
on 11/20/2013 | Category:
Sql Server Interview questions
| Views: 10569 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Select from following answers:
Use COALESCE
Use EXISTS
Use IS_MEMBER
Use EXP
All Above
SELECT e.*
FROM employee e
WHERE EXISTS
( SELECT * FROM contractors c WHERE c.SSN = e.SSN );
Show Correct Answer
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< Previous :
CREATE TABLE employee ( id_num int IDENTITY(100,10 ...
Next > :
What is Gridview_SelectedIndexChanged and Gridview ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
Which of the following statement is TRUE regarding INSTEAD OF triggers ...
How to generate grand total for the total column as a separate result ...
Which of the following datepart argument is used to get the MINUTE val ...
What is the output of select ISNULL(10, getdate()) as 'IsNullWithD ...
What is the output of select COALESCE(10, getdate()) as 'COALESCE& ...
Which of the following CANNOT be passed back as an output parameter fr ...
Which word is missing from the following statement to create a stored ...
Which of the following is the standard four-part naming convention whe ...
Latest Interview Questions
What is Gridview_SelectedIndexChanged and Gridview_RowCommand events i ...
Which Gridview events called first?
How many ways of finding controls through Javascript?
In which Gridview Events,We change Label(inside gridview) text or fill ...
What piece of code is missing when navigating to next/previous page in ...
What should be the attribute for a Model property that corresponds to ...
How does Garbage Collector works?
What is the maximum capacity of a DataTable in ADO.NET?
More ...