Filename with out extension using Shell Script

#!/usr/bin/sh

MYFILENAME="/xyz/abc/myfile.txt"

echo "File Path: ${MYFILENAME%/*} o/p :/xyz/abc"
echo "FULL Filename: ${MYFILENAME##*/} o/p :myfile.txt"
echo "File Extension: ${MYFILENAME##*.} o/p :txt"
echo "Filename with out extension: ${MYFILENAME%.*} o/p:myfile"

Select Nth row from a table

Retrieve only the Nth row from a tableSELECT * FROM empWHERE rowid = (SELECT rowid FROM emp WHERE rownum <= 5 MINUS SELECT rowid FROM emp WHERE rownum ‹ 5); SELECT * FROM empWHERE rownum=1 AND rowid NOT IN (SELECT rowid FROM emp WHERE rownum ‹ 5);

Retrieve only the x to yth row from a table


SELECT *FROM emp
WHERE rowid in (
SELECT rowid FROM emp
WHERE rownum <= 7
MINUS
SELECT rowid FROM emp
WHERE rownum ‹ 5);


To get every Nth row from a table.

SELECT * FROM emp
WHERE (ROWID,0) IN (SELECT ROWID, MOD(ROWNUM,4)
FROM emp);


SELECT *
FROM ( SELECT rownum rn, empno, ename
FROM emp ) a
WHERE MOD(a.rn,4) = 0;