Answer / sudheer

select salary from employee e
where 100=(select count distinct salary) from employee where
e.salary<=salary

Answer / goutham4mail@gmail.com

select top 1 * from Emp where Sal in
(select top 100 Sal from Emp order by Sal desc) order by
Sal asc

Answer / soumya

select * from (select rownum, salary from emp order by
salary ) where rownum=100;

Answer / lince

select T.* from(
select row_number() over (order by salary desc)as rno,salary from table )T
where T.rno=100

Answer / xyz

select rownum, salary from (select salary from employees order by salary desc)
where romnum<=100

Answer / ethayan

select salary from (select salary from sample where
rownum<11 order by salary desc) where rownum<2

Answer / ramu

select top(100) salary from table1 where salary not
in(select top(99) salary from table1)

Answer / murali

select salary from (select salary from table order by salary
desc) v where rownum<=100

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

What is package in pl sql?

0 Answers  

Is sql a backend?

0 Answers  

What is difference between db2 and sql?

0 Answers  

What is meant by temporal data?

0 Answers  

how is exception handling handled in mysql? : Sql dba

0 Answers  

how to decrement dates by 1 in mysql? : Sql dba

0 Answers  

Can i possible to see Table Details ? Ex : Table Name Date Time User Emp May/18/2010 12:59pm Scott

3 Answers  

How would you pass hints to the sql processor?

0 Answers  

Why is sql important?

0 Answers  

How do you create a unique index?

0 Answers  

What is mutating table error?

0 Answers