3 test limit and offset conditionally
4 test limit and offset field wise applying condition.
5 test limit and offset field wise on multiple conditions using or,and.
6 test limit and offset field wise on in operator.
7 test limit and offset field wise on between operator.
8 test limit and offset field wise on like operator.
10 2.create three tables emp,dept and loc
11 Join the three tables in different combination apply limit on them.
13 3. Create emp table with id int,name char(20),job char(10),salary double,doj date, deptno int,mgrno int
14 a) Apply self join and limit on emp.
16 4. create table t1, t2 , t3
17 take 5-6 field in each
18 Apply join on aggregate fields the apply limit on them.
20 4. create table t1, t2 , t3
21 take 5-6 field in each
22 Apply join on aggregate fields the apply limit on them.
24 4. create table t1, t2 , t3
25 take 5-6 field in each
26 Apply join on aggregate fields the apply limit on them.
28 5. new case wwill be written according to Ivan Bayross page-426 no:2(d),(e) (by Nihar)