Answer Posted / jithendranath.g
select z2.sal from emp z1, emp z2
where z2.sal <=z1.sal
group by z2.sal
having count(z2.sal)=&n
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What privilege is needed for a user to connect to oracle server?
Explain about the analyze command in oracle?
How is it different from a normal table?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
what happened to the global index when I truncate the data in one of the partition?
How do you find current date and time in oracle?
What is oracle datasource?
what is the dual table in oracle?
Can we commit inside a function in oracle?
Explain oracle instance.
What are the different types of trigger and explain its various uses and functions?
What are operators in oracle?
What is difference between cartesian join and cross join?
How to rename an index?