some simple commands of SQl..
USE OF WHERE:
SQL> select * from student20903 where Dob='01-JAN-88';
ROLLNO FNAME LNAME ADDS DOB MOBNO
---------- ---------- ---------- ------------------------- --------- -----------------
201 Salekin Ansari vashi 01-JAN-88 9920202021
USE OF OR and AND:
SQL> select * from stdnt_marks where sem1 > 70 OR (sem1 80);
ROLLNO SEAT_ SEM1 SEM2
---------- ----- ---------- ----------
202 AB02 86 66
204 AB04 86 86
SQL> select * from stdnt_marks where sem2 > 70 OR (sem1 80);
ROLLNO SEAT_ SEM1 SEM2
---------- ----- ---------- ----------
201 AB01 56 76
204 AB04 86 86
USE OF IN:
SQL> select * from stdnt_marks WHERE sem1 IN ('46');
ROLLNO SEAT_ SEM1 SEM2
---------- ----- ---------- -----------------------
203 AB03 46 56
USE OF BETWEEN:
SQL> select * from student20903
2 WHERE dob BETWEEN '01-MAR-90' AND '01-MAR-94';
ROLLNO FNAME LNAME ADDS DOB MOBNO
---------- ---------- ---------- ------------------------- --------- ------------------
201 Salekin ansari Vashi 01-JAN-88 9920202021
202 Rohan patil Thane 29-FEB-92 9967202021
USE OF LIKE:
SQL> select * from student20903 where Fname LIKE 'Mahesh';
ROLLNO FNAME LNAME ADDS DOB MOBNO
---------- ---------- ---------- ------------------------- --------- ----------
204 Manju choudhari airoli 11-JAN-86 9029794139
USE OF ORDER BY:
SQL> select *from stdnt_marks ORDER BY Sem1 Desc;
ROLLNO SEAT_ SEM1 SEM2
---------- ----- ---------- -------------------------
202 AB02 86 66
204 AB04 86 86
201 AB01 56 76
203 AB03 46 56
USE OF GROUP BY:
SQL> select rollno,Sum(sem1),Sum(sem2) from stdnt_marks group by rollno;
ROLLNO SUM(SEM1) SUM(SEM2)
---------- ---------- -----------------------------
201 56 76
202 86 66
203 46 56
204 86 86
Like it on Facebook, Tweet it or share this article on other bookmarking websites.