What Is The Command In Windows That Shows The Results Of All Of The Following

UNIX Command effects?

(1) who | grep 'mary'
Show the logins for mary but also for maryjane, emmary, and bramaryokovich.

(2) who | grep '^mary '
Just show mary and maryjane.

(3) grep '[Uu]nix' ch?/*
In all the files that do not begin with a dot, in all the three-letter directories that begin with ch, show the lines with unix or Unix somewhere in them.


(4) ls -l | sort +4n
List all the file names in the current directory, one per line, with a bunch of info about each one, and sort that list numerically by the 4th field, which by the way is the group owner, so a numeric sort is a bit silly. I think this one should be sort -k 5n anyway.

(5) sed '/^$/d' text > text.out
Take the standard input and delete all empty lines but put the results in the file text.out.

(6) sed 's/\([Uu]nix\)/\1(TM)/g' text > text.out
Take the standard input and tack "(TM)" to each occurrence of "Unix" or of "unix" and put the results in the file text.out. I would have gone with "™" because it looks cooler.


(7) date | cut -c12-16
Display the current date in the current locale, but show only the hour:minute (columns 12 through 16). This works only if your locale is "C" or one of the ones whose time starts in column 12.


(8) date | cut -c5-11,25- | sed 's/\([0-9]\{1,2\}\)/\1,/'
Display the current date in the current locale, but show only the

date | cut -c5-11,25-
Sep 28 2012

columns 5 through 11 ("Sep 28 "), and then show columns 25 through the rest of it, which happens to be the year. But then replace each 1-2 digit substrings with its 2-digit version. This works only if your locale is "C" or one of the ones whose columns line up this way.

A better way is to use the date [+FORMAT] style, so you can pick and choose which fields to show.

date '+%d-%b-%Y'
28-Sep-2012

Which Windows PE command would pipe the output of one program to anther program?

Well, think about it this way, The pipe symbol on a computer is |.

SQL- I just need queries for the following questions?

Hands-On Assignments
To determine the exact name of fields used in the tables for these exercises, refer to the tables in the Just Lee Books database, or use the DESCRIBE table name command to view the table’s structure.
1. Display a list of all data contained in the BOOKS table.
2. List the title only of all books available in inventory, using the BOOKS table.
3. List the title and publication date for each book in the BOOKS table. Use the column heading “Publication Date” for the Pub date field.
4. List the customer number for each customer in the CUSTOMERS table, along with the city and state in which the customer lives
5. Create a list containing the publisher’s name, the person usually contacted, and the publish-er ’s telephone number. Rename the contact column “Contact Person “in the displayed results. (Hint : Use the PUBLISHER table.)
6. Determine which categories are represented in the current book inventory. List each category only once.
7. List the customer number from the ORDERS table for each customer who has placed an order with the bookstore. List each customer number only once.
8. Create a list of each book title stored in the BOOKS table and the category in which each book belongs. Reverse the sequence of the columns so that the category of each book is listed first.
9. Create a list of authors that displays the last name followed by the first name for each author .The last names and first names should be separated by a comma and a blank space.
10. List all information for each order item. Include an item total, which can be calculated by multiplying the Quantity and Paid each columns. Use a column alias for the calculated value to show the heading “Item Total” in the output