Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by cgordon
-
AWK Script: Testing for Null values
This is part of an AWK script called from a batch file. grep AVL filename | awk -f ntnirpt.a In ntnirpt.a, the first few lines describe the format. rsv = substr($0,14,2) .. then a series of counters, based on the RSV indicator. A = A+1, B = B+1, ... Then a print statement. I tried to... -
AWK Script: Testing for Null values
Hi, I have an AWK script that worked until the data format changed. The 14th & 15th spaces are named RSV. This used to be only one space (until recently). Based on the value in RSV, I will print to a file in using PrintA or PrintB (different formats). 1545016908374 AVL111111... -
SQL: How can i get the 10 greatest values.
In Oracle use a subquery. From the Oracle course: select ename, sal from emp e where 10 > (select count(*) from emp where e.sal < sal) order by e.sal In SQLServer use: select TOP 10 ename, sal from emp order by sal
