UNIX for Dummies Questions & Answers

Hi..

I am new to Unix and trying to learn.
I have a small doubt like if we can use logical operators in searching.

My problem is I have a file which has name , roll no and percentage and I need to get the records of the students whose percentage is below certain value and then sort them by their roll number??

I tried using awk and grep but I am not getting.

ThankQ for ur time........

Can you show us your input and code you wrote?

I had created a file of my own and trying to work on some queries.
file:

Code:

John         1         98
Peter         2         67
Mary         3         86
Rita          4          85

Now I wanted to get student with mark less than 90 and sort by roll number..

I am trying to use awk and grep but not getting it.

Can you show us what you tried?

Code:

awk '{print $23}' filename | grep > 90