0
Records are the data that's stored in a database and a query is a command used to display and/or manipulate records (for example, adding/deleting records, displaying records by a search term, sorting records).
Wiki User
∙ 10y ago
A query is a request for data from a database using specific criteria, while a record is a single row of data within a database table that contains information related to a specific entity or object. Queries are used to retrieve records that match certain conditions or criteria specified by the user.
Add your answer:
Earn +20 pts
What do you use to find a particular record or group of records in a database?
To find a particular record or group of records in a database, you can use a query language like SQL. By writing a query with specific conditions, such as matching values in certain fields, you can retrieve the desired information from the database.
When you are pulling or extracting information out of the database with a query - you can use to set conditions that must be met for a record to be displayed?
To set conditions when querying a database, you can use the WHERE clause in your SQL query. This clause filters the results based on specified conditions. You can combine multiple conditions using logical operators such as AND, OR, and NOT to further refine your query results.
When you want to extract data from two or more tables you use an query?
When you want to extract data from two or more tables, you can use a SQL JOIN query. By using JOIN clauses, you can combine rows from different tables based on a related column between them. This allows you to retrieve data from multiple tables in a single query.
What is the difference between query and inquiry?
A query is a specific request for information or data, usually formal and structured. An inquiry is a broader investigation or exploration into a subject or issue, often with the aim of gaining understanding or knowledge. In general, a query seeks a specific answer, while an inquiry involves a more open-ended search or examination.
What request for specific data from a database?
A query is a request for specific data from a database. It is written in a structured query language (SQL) and is used to retrieve information based on specific criteria or conditions defined in the query. The query command searches the database for records that match the criteria specified in the query and returns the results in a structured format.
Explain the concept of database record and recordset?
A database record is a single row in a database. A recordset (or cursor) represents a query, and looks like (part of) a record or row. It is actually a row of the query, or virtual table representing the query. When you submit a query that returns data, you create a recordset and the database fills it in with the first record that matches the predicate clause. You do what you need to do with that data. When you need the next record, you fetch the next row, and so on and so forth. Some recordsets represent more than one row at a time. That is up to the database and your program design, but the concept is the same - the recordset is all or part of the resultset from the query.
How cross tab query is different from simple query?
No i don't know that's why i asked you
What do you mean by adhoc query capability in rdbms?
It means the capability to record- at-a time access.
What calculates a statistic for data that is a grouped by two different types of information?
A. in sum query B.group query C.statistic query D. none of the above The right answer is D. None of the above
What is used to find information a specific record or a specific field entry based on specific characteristics of the information?
A query.
What is used to find information on a specific record or a specific field entry based on specific characteristics of the information?
A query.
What is used to find information a specific record or a specific field entry based on specific characteristics of the information.?
A query.
What is a record set object?
A record set object is a data structure that contains a group of records or rows retrieved from a database table or query result. It typically allows for iterating through the records, accessing field values, and performing operations on the data. Record set objects are commonly used in database programming to interact with and manipulate database query results.
What is record source in Microsoft Access?
In reality it is just a table that can provide you with your record source. However, you can use queries to provide the data in different ways and do some processing on it that can be used. A form can present the data in different ways and do some processing, as can a report. However, they are still all getting their data initially from table, even when one query is based on another, or a form or table is based on a query. It is also possible to link Access to external data sources.
What is the difference between query and inquiry?
A query is a specific request for information or data, usually formal and structured. An inquiry is a broader investigation or exploration into a subject or issue, often with the aim of gaining understanding or knowledge. In general, a query seeks a specific answer, while an inquiry involves a more open-ended search or examination.
Can write query within the query?
Yes, you can have a query inside a query. That is known as a sub-query.
You wants to print a single record in crystal report using vb6 but you don't where and how you write query to retreive single from database?
In Crystal Reports, you can write the query directly in the report designer. In the "Database Expert" window, right-click on "Add Command" and write your SQL query to retrieve the single record. After defining the query, you can link it to your report elements to display the data accordingly. Using VB6, you can then call the Crystal Report Viewer to display the report with the single record retrieved from the database.
