sunojsm Warnings : 1 New User
Joined: 21 Jun 2004 Posts: 33 Location: Andorra
|
|
|
|
Hi all,
Could any one give the explanation abt this query
select a.salary from emp a where 2 = ( select count(*) from emp b where a. empno < b.empno);
where empno is primary key.............
let me have a table which has 20000 records, which has serialno as primary key starting from 0 to 20000 . i want records which has the serialno frm 10000 to 15000 . i wan t the exact query....
bye |
|