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;

2. Tell me about a time when you had to use your presentation skills to influence someone's opinion.

0 Answers   Strad Energy,

---

In HSE what is Lost time accident? why it is to be reported within 48 hrs to gov.authorities ?

0 Answers  

---

What is meant by VSWR?

2 Answers  

---

please answer the following question: A table contains the monthly sales data for the 12 months of a year and for the 4 sales zones where each zone has 8 districts.The table is defined in WORKING-STORAGE SECTION.What is the size of the defined table in number of bytes? write statements to calculate the total sales for each month.

0 Answers  

---

what is your experience with computer-aided design software.

0 Answers  

---

what is meant by safety in construction?

3 Answers   CAE,

---

i need to alone print a number no text by using if statement .say some idea

0 Answers  

---

what is different between static block and public static void main??

0 Answers   HCL,

---

i am astubent of BE3rd year currently in 6th semester branch information technology till now i have 73% near about in each semester the problem with me is that i have got only 58%in 12th class n 55%in 10th class bcoz of my health now i am ok i have got 2 year loss also bcoz i have not giveen the exam in class 12th rite now i am prep for GATE i am working hard pls tell will i get a good job in future in the good company bcoz my inter percent were not gud pls tell me help me pls

0 Answers  

---

I have a backlog in Computer Graphics and unable to clear that subject since 2007. Im from JNTU hyderabad. I dont have internal marks, so im unable to clear the subject. Is there any legal way to get my degree bcos of which i cant get proper job. Please help me.

0 Answers  

---

what is the difference between core java and advance java

0 Answers  

---

four jobs j1,j2,j3 and j4 are waiting to be run. Their expected runtimes are 9,6,3 and 5 respectively. In order to minimize average response time, the jobs should be run in the order: a) j1j2j3j4 b)j4j3j2j1 c)j3j4j1j2 d)j3j4j2j1

2 Answers   TCS, UGC NET,

---