Rownum in SQL

SQL is the most demanding skill nowadays.

ROWNUM:

a row num is a number for each record in the database.

it can be changed whenever we insert, update, and delete records from the table.

it is used to fetch specific records from the table.

Drawbacks:

it is used only for =1 , < and ≤ only.

it cant be used s like =3,>,=>.

if we are required to use other than 1 we have to implement an inner query for the same.

Examples:

1. Display all records from the table.

2. Display the first record from the table?

3. Display the second record from the table?

here we can see no result we get.

so for that, we need to implement an inner query for the same.

here the query to display second records from table.