Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
1133Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
1470Two 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.
1893Post New Databases AllOther Questions
What is the importance of database partitioning?
Which database does facebook use?
What is lagging in DBMS ?
Does facebook use graph database?
what is tkprof tool and how it is used???
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
What is the difference between database and server?
how can you perform lookup range in lookup stage expalin in detail?
Explain entity set?
Explain storage manager?
can u combine pipeline parallelism and partition parallalism? how and whan?
What is the best database software for small businesses?
How is image stored in database?
What are the types of indexes that are present inside a database?
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.