0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
What is a correlated query?
Correlated query has a subquery in it which accesses the column name of a table alias which is outside the subquery.
What is the difference between primitive flow table and state transition table?
dont know haha :P
Difference between SQL and OQL?
in some cease both are the same they use query language but in fact the out puts are very deference
What is the difference between a filter and a query?
A query is a function designed to output a response. A filter is a restriction designed to weed out irrelevant or unwanted responses.For example, if one were to google information on monks, but not the television show Monk, one might parse the query as: monk -tv -"Tony Shalhoub". The first term would be the query, and the next two terms (each marked with a minus sign) would be the filters.
What is the difference between a pictograph and a tally table?
A tally chart does not show pictures. A pictograph shows you pictures.
What is the difference between query datasheet and a table datasheet?
A query datasheet displays the results of a query operation, showing data based on specified criteria or calculations. A table datasheet displays the data in a table format, representing information stored in a database table. In essence, a query datasheet is derived from a table datasheet and is dynamic based on the query criteria.
What is the difference between reports and queries?
query takes a table and given the criteria entered into it it displays the results that meet that search. While a report just spits out a table in the database
What is the difference between a query and a report?
A query (inquiry) is seeking information. A report provides information.
What is the difference between update and append query?
Update queries modify information within a record at one or more fields at a time.Append queries copy complete records at a time, adding to the existing set of records in a table.For example, if an "Address" field needs to be changed for the records in a table, you can use an update query to make that change. If you have two tables with various "Customer Information" listings, you can use an append query to copy the records of one table to the other.
What is the difference between Dynaset and snapshot in VB?
a dynaset object can be used to retrieve information from a recordset and use the resault of the query to then edit the records and it also can get resaults from more than one table. On the other hand the snaphot gets information from only one table on the query and the data can not be edited or updated
What is the difference between a pool table light and a billiards table light?
There is no difference.
If you delete query does it delete the original information in the table?
Your question is unclear. If you mean if you delete a query, then it does not affect the data in the table. Deleting any kind of query does not affect the data in any table it uses. If you mean if you run a Delete query, then yes the data in the table will be deleted. That is what Delete queries are for.
What is the difference between hql and sql?
one of the difference is HQL does not support distinct but SQL supports the distinct in the query
Where does the destination table in an Append query show in the query grid?
It does not show in the query grid. On the Append To line you can pick the fields in the destination table that you want values to be appended to. The query grid is just for specifying what fields and records you want to be added to the destination table, so it only needs to show the source table.
The total number of records in an opened table is displayed?
To display the total number of records in an opened table, you can use the SQL query: SELECT COUNT(*) FROM [table_name]. This query will return the total number of records present in the specified table.
What is query Optimization?
Queries of a database can be fast or slow. Depends on a lot of things. The size of the table, the amount of data you are requesting from the query, etc. One of the ways a dba can help query optimization, is by "updating statistics" on a table. Statistics of a table allows the query to find the most efficient way to gather the data from the table.
What is the Difference between transaction and query?
The query is simple set of insert,update,delete statement where as transaction is a set of statement which follows ACID properties.
