Answer / shafeeq

Select max(salary) from emp;

Answer / pradeep kolakala

Select max(sal) from ithpharma.UserRole where version
not in (select max(sal) from ithpharma.UserRole)

What is a nvl function? How can it be used?

0 Answers  

---

What is a cognitive schema?

0 Answers  

---

List the types of joins used in writing subqueries?

0 Answers  

---

How to find the date and time of last updated table?

4 Answers  

---

Difference between the “verify” and “feedback” command?

0 Answers  

---

what is null value?

9 Answers  

---

i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID

7 Answers   IBM,

---

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

2 Answers   Mind Tree,

---

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.

5 Answers   Microsoft, Oracle, TCS,

---

Write a simple Store procedure and pass parameter to it ?

3 Answers   Keane India Ltd,

---

how to find the second highest salary in a given table????

5 Answers  

---

which sql command we can use to get a print out from oracle?

2 Answers   iFlex, INDUS,

---