Related questions

0 votes
0 answers
asked Apr 12, 2017 in Python by anonymous
0 votes
2 answers
BJSHUB - is a place to gain and share knowledge. It's a platform to ask questions and connect with people who contribute unique insights and quality answers.

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, 2017 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, 2017 by vidya (500 points)
...