Author Topic: How to list Top 10 salary, without using Rank Transmission?  (Read 156 times)

0 Members and 1 Guest are viewing this topic.

Offline CyborgRepublic

  • Full Member
  • *
  • Posts: 202
  • Karma: +0/-0
    • View Profile
How to list Top 10 salary, without using Rank Transmission?
« on: September 17, 2008, 12:03:11 PM »
Someone asked me.. hwo to make a top salary report w.o using page rank.

if it is a flat file then answer is write,if it is relational souce then you need to go to source qualifier properties there you actually write the query like

   
Code: [Select]
select distinct a.* from t1 a where 10=(select sal from t1 b where a.sal>b.sal)  i think this works.

Techronnati | where technology never sleeps

How to list Top 10 salary, without using Rank Transmission?
« on: September 17, 2008, 12:03:11 PM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
5 Replies
204 Views
Last post August 24, 2008, 05:13:39 PM
by h2obubbler
30 Replies
895 Views
Last post Yesterday at 12:00:07 PM
by h2obubbler
3 Replies
47 Views
Last post March 30, 2010, 04:51:24 PM
by MrSpecialist
1 Replies
127 Views
Last post September 16, 2014, 01:33:12 AM
by Corps
0 Replies
54 Views
Last post August 28, 2016, 09:14:36 AM
by rpmolecule

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.