Interested to Buy Any Domain ? << Click Here >> for more details...
display the second highest salary department wise in
employee table
- 1 Answers
- 7635 Views
- SoftSol, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
hi this is amit..please help me to out this problem Objective 8: Create Resources (Function libraries) Requirements: Create a new order with the Flight Reservation application. 33. Use the script created above. 34. Write a function using VBScript that will take a date as an input and add 10 to it. i.e. if the date is passed as “15/08/2008” then after adding 10 it should become as “25/08/2008” 35. Use this function to parameterize the step used to enter “Date of Flight” 36. Run the pack thanx & regards
gsm features
how to prepare for an written exam for any type of company?
what two ways you can use to ensure that visual basic does not allow uncleared variables?
. Give the C language equivalents of the following a)Function returning an int pointer b)Function pointer returning an int pointer c)Function pointer returning an array of integers d)Array of function pointer returning an array of integers
verbal quiz and answers
what is the number of water, sand and cement required for moulding brick?
Hello everybody, I have applied for the AAI jr executive ATC exam. I am from CSE branch. Is Exam paper for the CSE and other branches same or not? Because I don't have knowlwdge on Electronic subject? Can any one please send me the previous exam papers for AAI Jr Executive of CSE branch My id is: naveen.kocherla@gmail.com Thanks and Regards Naveen
how many protocols are available and what are they?
Briefly describe an experience of yours that illustrates your ability to clearly articulate and explain technical issues in a nontechnical manner
How many of 14 digit numbers we can make with 1,2,3,4,5 that are divisible by 4. Repetitions allowed.
what is the PID controller?
Hai friends this is Dara s. solanki, i done in B.Sc.(IT) i have an 2.3 years of exp in Manufacturing company in MIS giving support in SAP , 1 year back i did Sap course In MM Module. am trying from the day one to enter into the sap field but i was not.i kindly requesting all, please suggest me how to enter in to the SAP field. Looking for a job . i please help me and having any thing please let me know . i am in bangalore. my mail id is Dara.solanki@gmail.com. 8431455753
in which website , i can able to get the electrical basics.?????????????
hai im going to face ibps SO IT officers grade 1 interview. if anyone had an idea plz tel me expected and experienced questions and mail to anusha_k_anu@yahoo.com
