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.
No Answer is Posted For this Question
Be the First to Post Answer
A design problem was given in which I was supposed to make a design for the data base for a given problem.
What is difference between data and database?
what is difference between delete and truncet ?
If the master device is full, how do I make the master database bigger?
Can you create a database in word?
define primary key index, bitmap index, hash index,virtual indwx
How much does it cost to build a database?
What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?
0 Answers BDI Systems, Google,
utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) LOAD B) REORG C) COPY D) EXPLAIN
What is the importance of database partitioning?
What is database client?
What is sqlcode -923 ?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)