can any one tell me the definition of a database query??

Question

database query
database query
database query
database query???????????????? definition plz

Answer 1

I assume you have background on database so let me just say that a database query is basically the commands in database. for example "Select airport_abbr,number_passengers FROM L_Airports INNER"

Answer 2

It is a question or instruction that you ask to your database. For example, let's say that you have a database that contains the names of your company workers, but you need to know or get only the workers who have a salary equal to $3,000 and who live are from California. Then you would use a SQL query like this:



SELECT * FROM table WHERE salary=3000 and state='California'



That would give you the information you need. You can use a query in your database for deleting information, or updating, etc. I hope you understand now what a database query is.



Jaime Montoya

[e-mail]

www.jaimemontoya.com

Answer 3

A database query, in simple terms, is a request for specific data from one or more tables or views in a database. Queries are typically programmed in SQL, which stands for "structured query language." Queries allow a user to select only the data they need, filtering out unwanted results, and even formatting the returned data as needed. Queries are what allow us to get information from the database. Hope this helps.

Answer 4

You want the technical definiton: Here goes:



Queries are the primary mechanism for retrieving information from a database and consist of questions presented to the database in a predefined format. Many database management systems use the Structured Query Language (SQL) standard query format.



Granted I do this for a living. I am a Windows Technical Support Analyst and run SQL queries every day.



It is an SQL script that is run against a database that retrieves information that you request within the script. For instance you want to find all the records in the table that have the name "Smith" in them, you would run "SELECT * FROM WHERE = 'SMITH'"



I hope that helps

Answer 5

A database query is basically a question asked of the database.



We usually do it in SQL structured query languange.



For example select count(*) from some_table;

would show you the number of rows in the table.



Select name from account_table where account = 1501;

would retrieve the name from the account_table for account 1501.



That's pretty much the introduction.



SQL is a very power query tool.



Good luck.

Answer 6

It is your choice of parameters for records you want the database to return to you.



In simple terms, it is a question you ask a database. If a database has, for example, names, addresses, and phone numbers, but all you want to see is records of people who live in Montana, you submit a query filtering for records that have Montana in the State portion of the address field.