473,320 Members | 2,052 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,320 software developers and data experts.

How do I display bottom performers

1
I have a queary in which I want to only display the bottom 20 percent of data for each manager. how would I just show the bottom 20% of data in a field that measures performnce while at the same time displaying all managers in the same query but a different field?
Feb 2 '07 #1
3 1558
Rabbit
12,516 Expert Mod 8TB
I have a queary in which I want to only display the bottom 20 percent of data for each manager. how would I just show the bottom 20% of data in a field that measures performnce while at the same time displaying all managers in the same query but a different field?
Planning on some spring cleaning?

I understand the first part of your question but I'm confused by the second. What are you trying to display for all managers in the same query but a different field?
Feb 2 '07 #2
MMcCarthy
14,534 Expert Mod 8TB
I have a queary in which I want to only display the bottom 20 percent of data for each manager. how would I just show the bottom 20% of data in a field that measures performnce while at the same time displaying all managers in the same query but a different field?
ED

It would help if you could post a sample query that returns the managers and data concerned.
Feb 3 '07 #3
NeoPa
32,556 Expert Mod 16PB
MetaData of the table(s) wouldn't hurt either.
In SQL there is a predicate to the SELECT clause that can take just TOP n% or TOP n records. Sorting by the performance field mixed with a 'TOP 20 PERCENT' predicate is conceptually what you need, but before that can be put together with the rest of your requirements you need to make them a little clearer and provide the table information mentioned above.
Feb 4 '07 #4

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

Similar topics

8
by: Harry Haller | last post by:
The right arrow in IE is displayed aligned to the bottom of the line. Is there any way I can display it aligned vertially in the middle? Example: <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01...
4
by: drew197 | last post by:
I am a newbie. I am editing someone elses code to make it compatible with Firefox and Safari. In IE, when you click on the proper link, a block of text is shown in a nice paragraph form. But, in...
1
by: Brian D | last post by:
Take a look at this page. http://tempsite.texwipe.com/test/ The code is too long to post here so just look at the source. It works flawlessly in IE, but in Firefox not so much. Here is the...
11
by: vila | last post by:
Hi, I would like to display digits with a 7-bar display, as in a pocket calculator. Any ideas about how to do this? Francis
1
by: owz | last post by:
This is what im trying 2 get Sales Figures for 2006 in £000's Sales staff name 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Max Min Total John Smith 24 30 15 17 30 15 86...
7
exoskeleton
by: exoskeleton | last post by:
hi guys..hope you can help me...my boss want me to edit our website and apply the tooltip thing, i mean the moving tooltip that follows the mouse.. please help...thank you... :(
3
by: Sjef Janssen | last post by:
I try to get a tabbed display work both in IE (6 and 7) and Firefox. The last does give a problem. What's going wrong here? I'm totally puzzled. <!doctype html PUBLIC "-//W3C//DTD XHTML 1.0...
15
by: cssExp | last post by:
hello, Rather than going on a wild explanation on what's the the problem, it'll be much quicker and easier if i let you look at it yourself, so I'll post my page source (actual contents taken out,...
2
by: wreed06 | last post by:
Hello, I have 2 problems. In my webpage, I have a dropdown list with a button that takes the user to a popup window specific to the option. I am using Firefox 2.0.0.13. I have successfully...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.