Answer Posted / niladri saha(oracle apps consu

SELECT EMP_NAME EmployeeName, SAL Salary
FROM EMP
WHERE SAL =
( SELECT SAL
FROM
(
SELECT
DISTINCT SAL
FROM EMP
ORDER BY SAL DESC
)
WHERE ROWNUM=2
);

This Query will list all the employees, having second
highest salary.

How do I quit sql?

893

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1018

---

What is the maximum size of sqlite database?

1039

---

What are the types of subqueries?

1013

---

Can we insert data into materialized view?

896

---

Where do we use pl sql?

942

---

What is the basic structure of an sql?

1031

---

What is pragma in pl sql?

1019

---

Why is %isopen always false for an implicit cursor?

1034

---

Can unique keys be null?

850

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3923

---

I need a function for a train ticket reservation please answer it thanks in advance

957

---

Write a sql query to find the names of employees that begin with ‘a’?

950

---

What is package in pl sql?

961

---

What is full form of rtm?

951

---