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 are the file systems used in Linux?

0 Answers  

---

how can i write a program in c of SPARCE MATRIX(data structure)?

0 Answers  

---

hi i am avinash ,i am doing ma b-tech(cse) final year and i have been detained for 2years due to attendance and i will be finished ma b-tech in 6 years ,plz tell me weather i will be eligible for government jobs like bhel, drdo,or any other private companies

0 Answers  

---

What is the difference between "type testing" and "product qualification"?

0 Answers  

---

MILITARY ENGINEER SERVICES

1 Answers   MES,

---

Implement the dictionary operations INSERT, DELETE, and SEARCH using singly linked, circular lists. What are the running times of your procedures?

0 Answers  

---

10. Write a program in ‘C’ language that will perform the following operation on double link list. Each node of this list contains the address of previous as well as next node. The previous pointer of first node & next pointer of last node should contain null. 1. Creation of list with as many records as user want 2. Search a node in the list 3. Deletion at last position 4. Display 5. Exit Create separate functions for each operation. The create () will be used to create the list. It should accept no argument & return the address of the starting node. Search() will search a node in the list. It receives rollno as argument & return that node if found otherwise return null. The delete () function will delete the last node. It does not receive any argument & return structure type value at last position. The starting node of the double list must be declared as external pointer variable. Each element of double link list will contain the following information Roll No, Std Name, Course. Use do-while loop & switch case for generating the above menu. The format of the output should is given below: S.No. Roll No. Student Name Course 1 cse01 Anil Singh B.Tech

0 Answers  

---

iam from engineering information technology ... can i write group 1 exams??

0 Answers  

---

What is the difference between a .PST file and a .OST file?

0 Answers   BMS,

---

Can one be shocked holding a wire carrying a very large current with a low voltage source?

0 Answers  

---

Phong shading refers to describe

1 Answers   NIC,

---

SQL How can make delete and insert in one query

0 Answers  

---