Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
1105Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
1437Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
1870Post New Amazon Databases AllOther Interview Questions
How will you change the instance type for instances which are running in your application tier and are using Auto Scaling? Where will you change it from the following areas?
Explain difference between machine config vs. Web config? : .NET Architecture
What are the different phases in grc risk management?
can any one explain me briefly erp pharma project including all modules,like how to tell this project in interview in terms of s/w testing
Explain update requests. What are its different types?
I am in god softwwrae compnay as SAP QM consultant Domain with Pharma industry, I have got an oppurtunity for creating Computer system Validation Documents in Reputed pharma company . Can any one please help me out to prepare the CSV documents.
Explain soap?
What is the use ofsap testing?
After first installation of Solaris 10, what and all the Securities We need to set and how ?
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
Is it possible to limit the number of reports run by a users at a time? How? What will happen if this limit is exceeded?
What is 0record mode.
What is a Key Date?
What is wide table?