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
How do you select an index for a table
what are different types of datasets? what are different characteristics or properties of those datasets? what are the advantages and disadvantages of each dataset on each other?
Explain storage manager?
Explain normalization in one line?
What is the Lock Based Protocol used for?
What is database client?
What is database and its types?
What are the advantages of normalizing a database.
Is data lake a database?
What are the concurrency problems a database faces?
what is the role of auditor in auditing data oriented applications?
How many indexes can be created on a table?
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)