GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Microsoft  >  Visual Basic
Go To First  |  Previous Question  |  Next Question 
 Visual Basic  |  Question 389 of 453    Print  
what is difference between sub query and co-query?

  
Total Answers and Comments: 1 Last Update: December 14, 2007     Asked by: pghare 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
December 14, 2007 00:59:00   #1  
debasis.yours Member Since: November 2007   Contribution: 11    

RE: what is difference between sub query and co-query?
Sub-query is an inner query that returns a result used by another outer query may be by means of an IN operator like the following:
select * from [dbo].[Orders] where [Customer_ID] IN (select Customer_ID from [dbo].[Customer] where [City] 'Kolkata')
A Co-query is a part of a UNION query.
A subquery can also be used with operator; but in that case it must have to be guaranteed that it will return only one row of result

 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : 1. Picture Box Acts as Container Object where Image Box not 2. Resize & Autosize  ...

Latest Answer : List index is the property for Listbox control if we add items to the list box list index will be created it will be start from 0Tab intex is tab movment to set focus the control when pressing tab key..this property we can set most all the visible controls ...

Latest Answer : Listbox: 1) Does not contain a text box to write an item, Item is added using Additem method only 2) Always shows all item in the list 3) Can contain a checkbox in the list ComboBox: 1) Can contain a text box to write an item, Item is added ...

Latest Answer : It is just like function and procedure.Msgbox functions returns the value,but the statement displays just we type in " ".It does not return any value.  ...

Latest Answer : Used to check how the form is closed. ...

Latest Answer : modal and modeless ...

Latest Answer : Normal Combobox chg event do not takes any argument but the dbcombobox takes one integer type argument i.e by default it is array as integer which is actually used if there is an crtl array ...

Latest Answer : A snapshot­type Recordset object is a static set of records that represents the results of a query. A snapshot­type Recordset object includes all values for all the requested fields in your query, whether you refer to them in code or not. A snapshot­type ...

Latest Answer : Dynaset:1. Can be formed by large number of tables resulting in Virtual Tables.2. Does not store on the Machine but occupy temporary memory that is RAM.3. The changes made in the database can be reflected in the this.4. Allows operations like edit and ...

Latest Answer : The ADO Command object is similar to the DAO QueryDef object in that both objects can be used to execute an SQL statement against a data source. Likewise, the Recordset object in both ADO and DAO can be used to view the contents of a table or the results ...


 Sponsored Links

 
Related Articles

jQuery - Basic Alphabetical Sorting

Learning jQuery Basic Alphabetical Sorting Now let s perform a sort on the Title column of the table We ll need a class on the table header cell so that we can select it properly geshibot lang html" Title Author s Publish Date Price geshibot mosgoogle To perform the actual s
 

Working with XML in Visual Basic

Working with XML in Visual Basic Extensive markup language and Visual Basic is the odd couple of the industry Visual Basic is one of the most common languages that are being used today This Microsoft introduced language was meant to be middle tier in characteristic but has managed to get the top tie
 

What is an Ad Hoc Query

An Ad-Hoc Query is a query that cannot be determined prior to the moment the query is issued. It is created in order to get information when need arises and it consists of dynamically constructed SQL which is usually constructed by desktop-resident query tools. This is in contrast to any query which
 

What is difference between call by value and call by reference in function?

The arguments passed to function can be of two types 1. Values passed 2. Address passed The first type refers to call by value and the second type refers to call by reference. For instance consider program1 main() { int x=50, y=70; interchange(x,y); printf(“x=%d y=%d”,x,
 

SDLC Model Basic Stages

SDLC or the Software Development Life Cycle refers to the steps involved in creating a software from scratch.  During earlier days, software used to be scarce and its creation was comparatively easier.  Developers could create any programs they want and experience no competition. I
 

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de
 

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof
 

Basic PC Skills

For those that have decided to walk into the world of technology, they may be overwhelmed by the types of knowledge that are available.  There are several code languages and words as well as different areas that you can move into.  If you are a beginner in technology, you can fin
 

Importance of Proper English during Job Interview

Importance of Proper English during Job Interview Your job interview is crucially important and it will determine whether or not you will get the job Depending on the type of job you re going for it is very important for you to use proper English In most cases jobs which offer higher salaries will h
 

Scholarship Basic Facts

Scholarship Basic Facts A scholarship is a financial award that is given to students by colleges universities or other organizations The goal of a scholarship is to enhance the education of the student There are a wide variety of scholarships available and each scholarship will require applicants to
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape