Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
584Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
919Two 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.
1374Post New Amazon Databases AllOther Interview Questions
What is the difference between with profit and without profit plans?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Why is c called a mid-level programming language?
list the types of linked list with aid of diagram?
why multiple inheritence concept is not supported in c#?
a cheque is received from a debtor and is deposited in the bank on the same day. what will be the journal entry?
what is your strength and weakness?
How do I fix error 0xc00005 in windows 10?
When rendering a list what is a key and what is it's purpose?
Which TV series do you like the most? Enlist some major characteristics of this series.
What is called Team
How will you divide your script into multiple actions? Why?
How to you change the title of the page by javascript?
I BTech fresher, passed out in year 2011, my percentage is under 60, I couldnt get placed for tht, given this situation I have no go but to get job anywhere, Im plannng to find a job in Call Center, in customer support role. How to convince the interviewer that I need this job? as most call centers do not offer jobs to B.Tech esp Customer Support jobs. Please help
What does count (*) do in sql?