You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
3 8728Post New Amazon Oracle General Interview Questions
Can a singleton class be inherited?
What are Naming Conventions in QMF?
what are the advantages of using them.
What is output spooling in sql*plus?
Explain what does the term "green architecture" mean? : Dot net architecture
How does the embryo turn from gastrula into neurula? How is the neural tube formed? What is the embryonic origin of the nervous system in vertebrates?
how u configure salary packaging and CTC?
What is Hot Issue Income for Hedge Funds?
Explain Dataware house architecture .how data flow from intial to end?
What does == mean in texting?
What is term velocity in agile?
Give some best books to artificial intelligence?
Is HDFS utilized in Cassandra? If yes, where?
Why block size is multiple of lrecl in jcl?
Which linux shell is best?