Buy Questpond's video subscriptions on
huge discount
.
Online: 3403
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 ...
Result of the following query,
SELECT * FROM Employee_ksm WHERE Employee_ksm.DepartmentId IN(SELECT DepartmentId FROM Department)
Posted by
Kmandapalli
on 1/22/2014 | Category:
Sql Server Interview questions
| Views: 1825 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Answer:
When we want to get the records from both the tables where the DepartmentId in Employee_ksm matches the DepartmentId in Department table.
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< Previous :
What is the output of the following query? SELECT ...
Next > :
What is the output of the following query? SELECT ...
Comments or Responses
Login to post response
More Interview Questions by Kmandapalli
What is the output of the following query? SELECT * FROM Employee_ksm ...
What is the output of the query, SELECT * FROM Employee_ksm E INNER J ...
What is the result of this query, SELECT * FROM Employee E, Departmen ...
What is the output of the following query? select * from Person wher ...
What is the output of the query, select * from Person where rowid in ...
How to update page data automatically into your application when you u ...
How to save data entered from front-end into a pdf file?
What is the meaning of the following query? Select EnrollmentDate, Co ...
Latest Interview Questions
What is the return type of @@Fetch_Status Function?
What do we mean by @@Fetch_Status in Cursor?
Suppose,i have one table named competency_details which has one column ...
Suppose,i have one table named competency_details which has one column ...
How to calculate column values in Sql-Server?
What will happen when we execute below query? select avg('123 ...
What is the use of Avg function in Sql-Server?
How to get values from Enum?
More ...