Re: Third largest salary

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 05/11/04 

Date: Tue, 11 May 2004 15:10:36 +0530

  hi mustafa,

  try something as:

  select *
  from <table> a
  where
  (select count(distinct salary_column) from <table> b where b.salary_column
>= a.salary_column) = 3

  replace column name and table name in above query

  --
  Vishal Parkar
  vgparkar@yahoo.co.in | vgparkar@hotmail.com

  "mustafa" <mustafakh@yahoo.com> wrote in message
news:b2ea01c43736$69aca3e0$a601280a@phx.gbl...
> Dear Sir
>
> I want to retrive data that will return 3rd largest salary
> paid employee from employee table using sql query.
>
> thanks

Relevant Pages

  • Re: Third largest salary
    ... i HAVE A TEST TABLE WICH HAS ONE COLUMN CALLED id ... I USED THE BELOW QUERY BUT IT RETURN 0 ROWS. ... >> paid employee from employee table using sql query. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Limitation of 255 fields
    ... > Dear Sir, ... > If I want more than 255 fields in one recordset generated using query then ... Tom Lake ...
    (microsoft.public.access.queries)
  • Re: Show & Tell bag revisited
    ... "Edwin Johnston" happened by and tossed out a query: ... No sir, ... I got one of the best bargains ever on ... that coin on eBay a few months back. ...
    (rec.collecting.coins)
  • RE: [Info-ingres] Error - E_US10CE in Ingres
    ... Does each part of the union run without error? ... Paul ... I don't see anything blatantly wrong with the rest of the query. ...
    (comp.databases.ingres)
  • Re: Delete query problem
    ... Thank you sir. ... my request for help, I thought of a work around. ... I look for in the delete query that works. ... >In order to delete from a table, ACCESS Jet needs to have information about ...
    (microsoft.public.access.queries)