How to use EXISTS operator
How to use subqueries with the EXISTS operators?
A subquery can be used with the EXISTS operator as "EXISTS (subquery)", which returns true if the subquery returns one or more rows. Example -
Select custID, CompanyName from Customers cu where
(Select OrderID from Orders o where o.custID = cu.custID)
Next Question >>
When you use EXISTS, you don't really return data - instead, you return a simple TRUE/FLASE regarding the existence of data that meets the criteria established in the query that the EXISTS statement is operating against.
Related Questions (MS SQL SERVER FAQs)
What are the privileges that can be granted on a table by a user to others in SQL Server?
What is the use of DESC in SQL Server Query?
What is the REPLACE function in SQL?
What is the FOREIGN KEY in SQL Server?
What is the advantage of Materialised View?
Which function is used to find the largest integer less than or equal to a specific value?
What are defaults? Is there a column to which a default can’t be bound?
How do I create primary keys in SQL Server?
What is the basic functions for master, msdb, model, tempdb databases?
What is a Subquery ?
How can we force to all the validation control to on an event?
How do you secure your configuration files to be accessed remotely by unauthorized users?
What is delay signing in ASP.Net?
How is the DLL Hell problem solved in ASP.Net?
Which is the process independent Session?
Do webservices support data reader?
Why is there no DataGrid control on the Toolbox?
How to create an array of Web Server Controls?
What are possible implementations of distributed applications in ASP.Net?
Why Session_End is not fired?
What is Shadowing in C#?
Can you override private virtual methods?
Can I use inline assembly or IL in C# code?
What are the Keywords in C#?
Why are there five tracing levels in System.Diagnostics.TraceSwitcher?
What is the datatype that allows the retrieval of data by a unique key?
What is difference between the System.Array.CopyTo() and System.Array.Clone()?
How do I do a case-insensitive string comparison?
What debugging tools come with the .NET SDK?
How to make a C# destructor virtual?
What is Local assembly cache ?
How do I hide my form?
What control do I use to insert Separator lines between Controls in my Dialog?
How can I run an EXE from within my application?
What is Global Assembly Cache Tool ?
How many Formats are supported by DateTimePicker?
How can I use a TextBox to enter a password?
How do I add custom drawing to a Button?
What are the fundamental and common properties of .Net controls?
What is Global Assembly Cache ?
What is ASP.NET AJAX?
What is the role of a ScriptManagerProxy?
Can we use multiple ScriptManager on a page?
List the server controls that come up with ASP.Net AJAX?
Describe Goals / Profits / Benefits of using ASP.Net AJAX?
Define the role of the UpdatePanel?
Could we nest the UpdatePanel within each other?
What role does the ScriptManager play?
Describe the technology that makes up AJAX?
What is AJAX? or Define the term AJAX?
Does XML let me make up my own tags?
What are XML naming rules?
What is XML?
What are the difference between XML and HTML.
What is well formed XML document?
What is SGML (Standard Generalized Markup Language)?
How does XML handle white-space in my documents?
What is a Document Type Definition (DTD) and where do I get one?
Does XML replace HTML?
How can XML be used?
Job Interview Question
What is the meaning of DLL?
Can interface have static member? Yes or No?
What command is used to create a table by copying the structure of another table in SQL Server?
- MS SQL
How do I dynamically load a control from a DLL?
What is AJAX? or Define the term AJAX?
Why is XML such an important development?
ASP.Net Interview Questions and Answers (FAQs)
C-Sharp (C#) Interview Questions and Answers (FAQs)
Winform (Windows Forms) Interview Questions and Answers (FAQs)
SQL SERVER Interview Questions and Answers (FAQs)
AJAX Interview Questions and Answers (FAQs)
XML Interview Questions and Answers (FAQs)
© www.faqpanel.com: 2009-2010, All Rights Reserved |
Terms and Conditions