Answer / krish

Query to get 1st max salary from each dept
 
SELECT maxsal, 
       deptno, 
       ename 
FROM   ( 
                SELECT   Max(sal) OVER (partition BY detpno ORDER BY sal)        AS maxsal, 
                         row_number over (partition BY detpno ORDER BY sal DESC) AS id, 
                         ename, 
                         deptno 
                FROM     emp) 
WHERE  id=1;

just place id=2 instead of id=1 for second max salary 
if ur are expecting more than 1 records with max sal 
replace ROW_NUMBER with DENSE_RANK()

http://netezzamigration.blogspot.com/2014/10/analytic-functions-in-netezza.html

Answer / madhu

select * from ( select country,empname,salary, dense_rank() over (partition by country order by salary) rank from emp) where rank <= 2;

What are the best practices while building a Cognos Framework Manager Package ? As in, what calculations would you not like to be handled in FM and rather get it directly from Database.

3 Answers  

---

17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?

3 Answers   TCS,

---

how can we improve performance of the reports?

6 Answers  

---

what are the dimensions that you have in your current project?list them?

0 Answers   IBM,

---

What is difference between informatica power mart and power center?

0 Answers  

---

write a query to display to 10 max record from the employee table?

2 Answers   HCL,

---

Name the types of report?

0 Answers  

---

I would appreciate if any one answer for this, I have faced the question like this, the question was Tell me some complex reports, which u faced?

5 Answers   SAIC,

---

what is a query subjects item?

1 Answers   HCL,

---

what is session parameters? what is use?

1 Answers   HCL, Satyam,

---

How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?

5 Answers   CTS,

---

diff b/w grouping and aggregation

1 Answers   HCL,

---