Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
- 0 Answers
- 808 Views
- Amazon, I also Faced
- E-Mail Answers
What are different types of clusters present?
Two 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.
Explain storage manager?
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
define primary key index, bitmap index, hash index,virtual indwx
What is a database example?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
What is ole db in ssis?
what are wrappers and build ups and what it's use?
What are different types of blocks used in stored procedure?
Explain natural key?
Difference between sql and mysql?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
