Interested to Buy Any Domain ? << Click Here >> for more details...
suppose we have a table in which 200 rows. i want to find
101 row ? what the query....
and how we find 4th and 5th highest salary and 1 to 10
highest salary
- 7 Answers
- 12679 Views
- I also Faced
- E-Mail Answers
Answer Posted / hemant
select * from emp where (rowid,0) in
(select rowid,mod(rownum,101) from emp)
and rownum=1
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is a clob in sql?
What is the difference between database trigger and stored procedure?
What is sql*loader and what is it used for?
How many postgresql users are there, worldwide?
What does <> sql mean?
How do you rank data in sql?
What is an alias command?
Are subqueries better than joins?
What is the primary key?
Why do we use procedures in sql?
How do you update a sql procedure?
explain the difference between bool, tinyint and bit. : Sql dba
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
explain advantages of myisam over innodb? : Sql dba
