Answer / nagendra maddi

SELECT DISTINCT *
FROM (SELECT deptno, sal,
DENSE_RANK () OVER (PARTITION BY
deptno ORDER BY sal DESC)

RANK
FROM scott.emp)
WHERE RANK <= 2;

my first question in huawei was ....1)Tell me about your self 2) oops concept 3)logic gates 4)ram and rom ,what is cache memory nd where it is located 5)diffrence between file system and data base 6) procedure of operating system 7)what is c# 8)high level language and machine language 9) and from mobile networkin !!!! hope thz will help you

0 Answers   Huawei,

---

An inversion is an array of numbers is any pair (i,j) such that i<j and A[i]>A[j]. What is the average number of inversions in an array of n distinct numbers? plz GIVE ME SOLUTION

0 Answers   TCS,

---

Why DG Set manufacturers do not give options for alternative fuels. They even do not allow to change at the cost of custmers.

0 Answers  

---

in intel 8086 why is the segment register content appended by zero to generate physical address?

1 Answers  

---

please explane me clusterd and non clusterd

0 Answers  

---

where is interrupt vector table is located??

1 Answers   Infosys,

---

what is defect tracking in sotware testing

0 Answers  

---

I DO HAVE APAST EXPERIENCE IN MY(SCHOOL/COLLEGE)WHERE I'VE HANDLED RESPONSIBILITY LIKE

0 Answers   Oracle,

---

MY interview Experience with TCS

1 Answers   TCS, Wipro,

---

Which is better field cad/cam in mechanical or film editing/animation is better salary wise?

0 Answers  

---

good morning! can u briefly explain the concept of syllolism and wat it mean?

0 Answers   BSRB,

---

what is Networking?

0 Answers  

---