Originally posted by G.MOHAN REDDY:
I need a quary for which to displaying top 5 salary names from Employee Table
[ February 09, 2004: Message edited by: G.MOHAN REDDY ]
Thanks, leo
http://www.jamonapi.com/ - a fast, free open source performance tuning api.
JavaRanch Performance FAQ
http://www.jamonapi.com/ - a fast, free open source performance tuning api.
JavaRanch Performance FAQ
[OCP 21 book] | [OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Originally posted by Paul Misoni:
If you'd like a more straightforward answer, try..
SELECT NAME, NUMBER
FROM TABLE1 A
WHERE 10 > (SELECT COUNT(*)
FROM TABLE1 B
WHERE A.NUMBER < B.NUMBER)
AND NUMBER IS NOT NULL
ORDER BY NUMBER DESC;
Originally posted by Amod Bhatia:
can any body pls expalain it with example
it will be gr8 full to me
I still not able to get the above query
This. Exactly this. This is what my therapist has been talking about. And now with a tiny ad:
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
|