report
Query Language is way for communicating from the database. It work as a interface between user and the Database. its not possible to generate a result from database without query language. Query language helps us to communicate with database.
A query is a way of extracting information from a database, usually by using certain criteria or requesting certain data
To display data returned from a query in a specific way.
To order the records in the answer to a query in a particular way.
A query can extract records in all sorts of ways, like finding ones that meet some criteria and listing them all together. It can do that very fast. If there are a huge amount of records, trying to extract them manually would be a very slow process. A query can extract data in different formats and even convert it to make it look different to the way it is in a table. It could be something simple like listing the extracted data in upper case. A query can also do all sorts of other things, not just extract information. Queries can be used to delete things or add data or update data and other things. A query is an essential element of a database. Without them you might as well just have your data on paper.A query can extract records in all sorts of ways, like finding ones that meet some criteria and listing them all together. It can do that very fast. If there are a huge amount of records, trying to extract them manually would be a very slow process. A query can extract data in different formats and even convert it to make it look different to the way it is in a table. It could be something simple like listing the extracted data in upper case. A query can also do all sorts of other things, not just extract information. Queries can be used to delete things or add data or update data and other things. A query is an essential element of a database. Without them you might as well just have your data on paper.A query can extract records in all sorts of ways, like finding ones that meet some criteria and listing them all together. It can do that very fast. If there are a huge amount of records, trying to extract them manually would be a very slow process. A query can extract data in different formats and even convert it to make it look different to the way it is in a table. It could be something simple like listing the extracted data in upper case. A query can also do all sorts of other things, not just extract information. Queries can be used to delete things or add data or update data and other things. A query is an essential element of a database. Without them you might as well just have your data on paper.A query can extract records in all sorts of ways, like finding ones that meet some criteria and listing them all together. It can do that very fast. If there are a huge amount of records, trying to extract them manually would be a very slow process. A query can extract data in different formats and even convert it to make it look different to the way it is in a table. It could be something simple like listing the extracted data in upper case. A query can also do all sorts of other things, not just extract information. Queries can be used to delete things or add data or update data and other things. A query is an essential element of a database. Without them you might as well just have your data on paper.A query can extract records in all sorts of ways, like finding ones that meet some criteria and listing them all together. It can do that very fast. If there are a huge amount of records, trying to extract them manually would be a very slow process. A query can extract data in different formats and even convert it to make it look different to the way it is in a table. It could be something simple like listing the extracted data in upper case. A query can also do all sorts of other things, not just extract information. Queries can be used to delete things or add data or update data and other things. A query is an essential element of a database. Without them you might as well just have your data on paper.A query can extract records in all sorts of ways, like finding ones that meet some criteria and listing them all together. It can do that very fast. If there are a huge amount of records, trying to extract them manually would be a very slow process. A query can extract data in different formats and even convert it to make it look different to the way it is in a table. It could be something simple like listing the extracted data in upper case. A query can also do all sorts of other things, not just extract information. Queries can be used to delete things or add data or update data and other things. A query is an essential element of a database. Without them you might as well just have your data on paper.A query can extract records in all sorts of ways, like finding ones that meet some criteria and listing them all together. It can do that very fast. If there are a huge amount of records, trying to extract them manually would be a very slow process. A query can extract data in different formats and even convert it to make it look different to the way it is in a table. It could be something simple like listing the extracted data in upper case. A query can also do all sorts of other things, not just extract information. Queries can be used to delete things or add data or update data and other things. A query is an essential element of a database. Without them you might as well just have your data on paper.A query can extract records in all sorts of ways, like finding ones that meet some criteria and listing them all together. It can do that very fast. If there are a huge amount of records, trying to extract them manually would be a very slow process. A query can extract data in different formats and even convert it to make it look different to the way it is in a table. It could be something simple like listing the extracted data in upper case. A query can also do all sorts of other things, not just extract information. Queries can be used to delete things or add data or update data and other things. A query is an essential element of a database. Without them you might as well just have your data on paper.A query can extract records in all sorts of ways, like finding ones that meet some criteria and listing them all together. It can do that very fast. If there are a huge amount of records, trying to extract them manually would be a very slow process. A query can extract data in different formats and even convert it to make it look different to the way it is in a table. It could be something simple like listing the extracted data in upper case. A query can also do all sorts of other things, not just extract information. Queries can be used to delete things or add data or update data and other things. A query is an essential element of a database. Without them you might as well just have your data on paper.A query can extract records in all sorts of ways, like finding ones that meet some criteria and listing them all together. It can do that very fast. If there are a huge amount of records, trying to extract them manually would be a very slow process. A query can extract data in different formats and even convert it to make it look different to the way it is in a table. It could be something simple like listing the extracted data in upper case. A query can also do all sorts of other things, not just extract information. Queries can be used to delete things or add data or update data and other things. A query is an essential element of a database. Without them you might as well just have your data on paper.A query can extract records in all sorts of ways, like finding ones that meet some criteria and listing them all together. It can do that very fast. If there are a huge amount of records, trying to extract them manually would be a very slow process. A query can extract data in different formats and even convert it to make it look different to the way it is in a table. It could be something simple like listing the extracted data in upper case. A query can also do all sorts of other things, not just extract information. Queries can be used to delete things or add data or update data and other things. A query is an essential element of a database. Without them you might as well just have your data on paper.
the difference between the way Access saves a record and the way Excel saves a row in a worksheet. Answer
Length and the way it's coded.
One is a simple way of doing it and one is a complicated way of doing it.
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.
A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.A crosstab query is a type of select query, but it displays the data in a different layout. A crosstab query can present data in a tabular layout which can sometimes be easier to follow than the way a standard select query does, although they will both show the same data. Say you were counting the amount of males and females that worked in each department of a company. A crosstab query will present the data in a table, maybe having the male and female headings at the top over 2 columns and the names of the departments down the side for each row. A Select query will take more lines to present the data. So for those kinds of situations using a crosstab query is better.
It depends upon the way you search the query.
To display data returned from a query in a specifically formatted way - APEX