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

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

what are %TYPE and %ROWTYPE? what is the difference?

7 Answers   ICICI, Saama Tech, Sail,

What is offset and limit in sql?

0 Answers  

Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 Answers  

What is the Query to print out the individual total number of duplicate row in sql.

5 Answers   TCS,

Are dml statements autocommit?

0 Answers  

What do you understand by pl/sql cursors?

0 Answers  

what is the bond code in materialized view?

0 Answers  

What is compute?

0 Answers  

how to convert character strings to dates? : Sql dba

0 Answers  

hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

8 Answers   Wipro,

how to convert character strings to numeric values? : Sql dba

0 Answers