Answer Posted / naresh
select * from emp e where 2=(select count(*) from emp where
sal>=e.sal);
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Can a composite key be null?
Do foreign keys improve performance?
What are the types of variable use in pl sql?
What are the different type of joins in sql?
What is the difference between having and a where in sql?
How do I get sql certification?
what are the drivers in mysql? : Sql dba
How to add a column ‘salary’ to a table employee_details?
What is composite primary key in sql?
Why are sql stored procedures used?
what is a database lock ? : Sql dba
What is parameter substitution in sql?
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...
How many triggers can be applied on a table?
What does rownum mean in sql?