How to select specific record from last or first:
Select col1,col2,col3 from(selectcol1,col2,col3, row_number() over(order by col4,col5 desc) RN)
Where RN=2;
Note: to select second record from last
Select col1,col2,col3 from(selectcol1,col2,col3, row_number() over(order by col4,col5 desc) RN)
Where RN=2;
Note: to select second record from last
https://googleweblight.com/?lite_url=https://docs.oracle.com/cd/B28359_01/server.111/b28286/pseudocolumns009.htm&ei=wkRMS7MF&lc=en-IN&s=1&m=618&host=www.google.co.in&ts=1464376440&sig=APY536w6uKm4EgWx93QTKwsXnLep823i3g
ReplyDeletehttps://googleweblight.com/?lite_url=https://docs.oracle.com/cd/B28359_01/server.111/b28286/pseudocolumns009.htm&ei=wkRMS7MF&lc=en-IN&s=1&m=618&host=www.google.co.in&ts=1464376440&sig=APY536w6uKm4EgWx93QTKwsXnLep823i3g
ReplyDelete