Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
1072Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
1400Two 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.
1845Post New Databases AllOther Questions
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
What does currency type mean in database?
What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?
What is the difference between database and server?
What are the advantages of using database?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
What is the best database software for small businesses?
What do you mean by foreign key and primary key?
Explain entity set?
How to do Data size testing? Who does this testing (Developer or tester)?
What are database connection details?
Can you tell any two advantages of stored procedures?
Can we use redis as database?
What are the tools used for backup and ticketing?
Explain storage manager?