Interview Questions Answers in Data Warehouse General

reddeppa reddy

{ City } bangalore
< Country > india
* Profession * software engineer
User No # 55102

Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 6
Users Marked my Answers as Wrong # 26

Questions / { reddeppa reddy }

Questions Answers Category Views Company eMail

Answers / { reddeppa reddy }

Question { Principal Finance, 11531 }

Disply the dname wise maximum salary

Answer

select deptid, max(sal) from department table group by sal

Is This Answer Correct ?

5 Yes

15 No

Question { Principal Finance, 11531 }

Disply the dname wise maximum salary

Answer

select departmentname,max(sal) from department table group
by deptid

Is This Answer Correct ?

1 Yes

11 No