display the second highest salary department wise in
employee table
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;
Is This Answer Correct ? | 6 Yes | 1 No |
write a progremme using function 0f prime no.?
what is advantages and disadvantages of vlan?
what are the artifacts in coding phase in SDLC????
How many rounds in dell interview process in dell
2 Answers DELL, IBM, Marvel ERP,
which is having more efficiency smaller power plant or bigger power plant? why?
hiii.. i wanna ask u is it neccessary to take coaching for preparing for interwiews for placement. because we have toclear the aptitude test
SIR i hv compleated b.tech(computer science engineering) with 82% marks. i want to join shipping corporation of india. it's my career dream. please i am eleasible or not?
3 Answers Shipping Corporation of India,
What is the difference between "type testing" and "product qualification"?
what is debugging?
WHY WE USE {} AT THE STARTING OF C PROGRAM
What are the main assumptions that we make when we model potential flow?
hi frnds,im from andhra pradesh.i gt selected in sbi exam.my interview is on 3rd may'10.i applied under bc-e category as i belong to muslim "shaik".but nw i came to knw that it does not apply to bank exams.plz help me out.i have bc-e certificate issued by my area mro in feb'10.is this sufficient r else i had to carry other certificate..