The query is as follows:
select * from my_table where rownum <= n
MINUS
select * from my_table where rownum < n
Posts
negative regexp
-
if you want to grep anything except foo, use grep -v or negative lookahead
echo -e 'foo\nbar\nboz'|grep -P '^(?!.*foo).*$' bar boz it is just so
beautiful ...
1 month ago
1 comment:
SELECT b.*
FROM (SELECT ROWNUM rownum1, my_table1.*
FROM my_table my_table1) my_table2
WHERE my_table2.rownum1 = 10
Post a Comment