answersLogoWhite

0


Best Answer

That's something like:

SELECT AVG(column) AS average_value_of_column FROM table;

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How would you write SQL query to show avarege number of something?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How to change a field to Uppercase in a query?

Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.


What is a simple query?

A simple query would do something like just list of data in the table, without any other elements such as conditions or sub-queries or being a parameter query or using functions or formulas. So if all you wanted to do was list of all the names of people in a table, that would be a simple query.


What is query explain with the help of an example?

Literally "query" is just another word for "question". So right up there is an example. In SQL, a query would be something like SELECT NAME FROM EMP WHERE DEPARTMENT = 'MARKETING';


What would be an avarege monthly recreational bill for a single person?

for me it would be a bout 1,000$$$ but for most people probably 700-900$


How do I create a SQL Select query that will return the number of columns not rows in my query result. So if my query returns 1 row with 5 columns I want the query to generate the number 5.?

I have the same question but well a not-so-elegant solution would be to define a view within your DBMS e.g. CREATE VIEW view_name AS (SELECT ...your_query) and then apply a SELECT COUNT(*) FROM view_name


How can you sort the results from an sql statement?

You can sort the results of a query by using the order by clause. Ex: Select * from tbl_employee order by emp_num The above query would sort the results by the employee number and display them. The default sort is ascending order. Ex: Select * from tbl_employee order by emp_num desc The above query would sort the results by descending order of employee number and display them.


What query do you use to extract data from two tables?

You would use a JOIN query for this.


Where can one find tutorials on writing queries?

Tutorials on writing queries can be found in a number of places depending on what type of query you would like to write. For example, if you would like to write a query letter to a literary agent, you can find excellent advice at Absolute Write. You can also visit your local library and purchase books on how to write query letters.


Why DBA understand query optimization?

he is the main person for the data administration for the relational database management systems. therefore, he needs to understand the query plan and be able to suggest the suitable query plan that would satisfy the query.


Why do data appear many times on a query using access database?

It will depend on the design of your table and your query. If you have done something like brought the table in twice into the design of the query you will get multiple records. There are occasions when you would need to bring in the same table twice, but usually you don't. If you have it in twice it will list records multiple times. Go to the design view of the query and if you see the table there more than once, delete the extra copies of it, so that there is only one. Then design your query and it should be ok.


What is a parameter queris?

a parameter query is a query that prompts the user to enter specific criteria every time the query is run. When building the query, you would enter the prompt in the criteria line under the field you want the information to be filtered from. For example, if you wanted to look at items that sold on a specific date each time you ran the query, your criteria line would look like this: [enter date of sale] So when you ran the query, before your results even appeared, a parameter box would pop up telling you "enter date of sale", the user would enter the date and then the filtered criteria of the query results will show.


What is a parameters?

a parameter query is a query that prompts the user to enter specific criteria every time the query is run. When building the query, you would enter the prompt in the criteria line under the field you want the information to be filtered from. For example, if you wanted to look at items that sold on a specific date each time you ran the query, your criteria line would look like this: [enter date of sale] So when you ran the query, before your results even appeared, a parameter box would pop up telling you "enter date of sale", the user would enter the date and then the filtered criteria of the query results will show.