Related questions

How to display nth highest record in a table for example?

0 votes
How to display 4th highest (salary) record from customer table?
asked Jul 29 in MySQL by vidya (500 points)

1 Answer

0 votes
  1. SELECT rownum,sal

  2. FROM (SELECT sal

  3. FROM emp

  4. ORDER BY sal desc)

  5. WHERE rownum < 5

answered Jul 29 by vidya (500 points)
...