How to test values returned by a subquery with the in operator?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Are resultset updatable?

0 Answers  


find 2nd highest salary of person using cursor concept?

6 Answers   HCL,


What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,


How to set the current database in ms sql server?

0 Answers  


What are the 3 types of schema?

0 Answers  


Where do you think the users names and passwords will be stored in sql server?

4 Answers   BirlaSoft,


How to count duplicated values in a column in ms sql server?

0 Answers  


If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,


Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,


What is a collation?

0 Answers  


What is indexed view?

0 Answers  


What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  


Categories