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;

what is a query for divide a table into two subtable?

0 Answers  

---

what is the PID controller?

0 Answers   Cadila,

---

hello sir, i'm persuing my B.tech final year in textile chemistry and have a diploma in electronics and communication...interviewer ask why you should adopt textile chemistry from electronics and communication....please give me the best answer... thank you

0 Answers  

---

why this companay? For example: Why Dell?

1 Answers   DELL,

---

why view is created in database

0 Answers   Daraz.pk,

---

what is the diffeence between SQL and ORACLE?

0 Answers  

---

Why do you want to work here

0 Answers   FLSmidth,

---

Hii can you help me step by step procedure for transfering data in textfields into sql database .mdf(also help me how to create database .mdf file) file after creating submit button in asp.net/ c#?????

0 Answers  

---

I m doing btech with computerscience branch.For every campus placement eligibilty criteriais is 60%.I have 65% in highschool and b.tech till now but secured 59.6% in intermediate. So would this percentage b considered as 60% or i wont b able to sit in exams?kindly post your views?

0 Answers   Infosys,

---

What is JVM and its role? What is the feature of platform independency in Java? How does it differ from C++?

1 Answers   Impetus,

---

main() { int arr[]={12,14,16,18,20} printf("%u%u";arr+1,&arr+1); } //tell me the answer of this question with proper reason..:)//

1 Answers  

---

How small can you make a computer? What are the limiting factors?

0 Answers  

---