This video is about pseudo columns.
PSEUDO COLUMNS ||SQL || ROWID||ROWNUM||FINDING NTH MAX,MIN SAL
1.WAQTD top 3 records from the table.
2.WAQTD top 5 records from the table.
3.WAQTD first records from the table.
4.WAQTD 5th records from the table.
5.WAQTD 5th & 10th records from the table.
6.WAQTD bottom 3 records from the table.
7.WAQTD bottom 5 records from the table.
8.WAQTD 1st & last records from the table.
9.WAQTD 5th minimum salary..
10.WAQTD 1st,3rd,5th,8th,10th maximum salary.
11.WAQTD details of employees who is getting 10th minimum salary.
#pseudocolumnsinsql
#rowid
#rownum
#nthmax
#nthminsal
