473,396 Members | 1,853 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

query to display name and average salary who are having age>50

24
hi all
i have a table called persons and the feilds are name,id,salary,age..i need to display the name and average salary of the people whos age is more than 50..what is the query for this..someone please tell me the query for this..

thanking you
Sep 25 '07 #1
4 1931
azimmer
200 Expert 100+
hi all
i have a table called persons and the feilds are name,id,salary,age..i need to display the name and average salary of the people whos age is more than 50..what is the query for this..someone please tell me the query for this..

thanking you
Name and average salary don't go together -- what would that mean? Do you need name and salary of people over 50; or do you need the average salary of (all) people over 50?
Sep 25 '07 #2
doll
24
Name and average salary don't go together -- what would that mean? Do you need name and salary of people over 50; or do you need the average salary of (all) people over 50?
hi
thanks for the reply..but i myself dont know what does the question mean..this was asked to me in a test and i dint know the query..name and avg salary wont go together is it..or you mean to say aggregate function does not go with name..i dint get you

thank you
Sep 25 '07 #3
azimmer
200 Expert 100+
hi
thanks for the reply..but i myself dont know what does the question mean..this was asked to me in a test and i dint know the query..name and avg salary wont go together is it..or you mean to say aggregate function does not go with name..i dint get you

thank you
  1. Please do not use this forum to solve your (or someone else's) coursework. It goes against the forum rules. Read and obey this please: http://www.thescripts.com/forum/faq.php?faq=posting_guidelines#faq_homework_or_cou rsework
  2. Please understand at least what you want before asking questions.
  3. It helps a lot to make an effort yourself...
Sep 25 '07 #4
doll
24
  1. Please do not use this forum to solve your (or someone else's) coursework. It goes against the forum rules. Read and obey this please: http://www.thescripts.com/forum/faq.php?faq=posting_guidelines#faq_homework_or_cou rsework
  2. Please understand at least what you want before asking questions.
  3. It helps a lot to make an effort yourself...
hi
ok thanks a lot...sorry
Sep 25 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

31
by: da Vinci | last post by:
OK, this has got to be a simple one and yet I cannot find the answer in my textbook. How can I get a simple pause after an output line, that simply waits for any key to be pressed to move on? ...
5
by: toylet | last post by:
Attached is some css codes for a website. It has 3 parts: top-bar, side-bar (on the left) and main-body. The top-bar has a mouseover menu called top-menu implemented via ul:hover. When the mouse...
1
by: Antar | last post by:
Hi, I'm kind of a newbie on DB management but I have to deal with a huge DB used for real time operations. I got a temporal table where current data is stored to work with frecuently, and then a...
9
by: David Trimboli | last post by:
In designing some of my pages (see http://www.trimboli.name/rune/goblinmagic.html for an example), I created a lot of markup to mimic the book upon which the pages are based. My thinking at the...
1
by: Valerie | last post by:
Hello everyone, I am new in PHP-programming but I am learning the basics of it. I've got a script that uploads a picture together with all data from the inputform, to the server and places the...
32
by: T. Crane | last post by:
Hi, I'm struggling with how to initialize a vector<vector<double>> object. I'm pulling data out of a file and storing it in the vector<vector<double>object. Because any given file will have a...
5
by: vicks | last post by:
Hi, I had just written the following code but not able to figure out why the sizeof() operator is printing the weired output when i give a function name as its operand? #include<stdio.h>...
5
by: quirk | last post by:
I am trying to write a script where a page is populated with some maths questions, user answers them (it's timed but I've left this bit out), gets results on same page and ajax takes their score,...
5
by: njsimha | last post by:
Hi, In the folowing XML snippet: <template1> <name>student</name> <elem1> <subelem1>65</subelem1> <subelem2>15</subelem2> </elem1>
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.