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
What is replicaset?
How do I manually create a database?
Explain storage manager?
How to do performance tunning a database in DB2 V8.2 UDB in linux
Differentiate between delete and truncate table?
what is difference between delete and truncet ?
How many indexes can be created on a table?
how node connect with cpu?
Clipper / DBF error
What is ole db provider for sql server?
what is tkprof tool and how it is used???
What is the default identifier of structure in C?
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)