Answer Posted / ayush

select *
from (select ename,empno,salary,dense_rank()over(order by
salary desc) rank from emp)
where rank =2

Which command is used to delete a package?

1093

---

How do you modify a trigger?

876

---

Can we create index on primary key?

916

---

What are aggregate functions in sql?

1091

---

what is the difference between blob and text? : Sql dba

964

---

Is sql procedural language?

921

---

What is the difference between mdf and ndf files?

1063

---

What is the difference between a subquery and a join?

1014

---

what is a tablespace? : Sql dba

1007

---

What is foreign key in sql with example?

892

---

What is the trigger in sql?

905

---

What are the different type of joins in sql?

908

---

What is the use of index in sql?

961

---

What is the difference between numeric and autonumber?

942

---

what are date and time intervals? : Sql dba

999

---