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
Write a query to retrieve for many to many relationships?
Give the syntax of exception handling used in DBMS?
what is transaction state, buffer management, shadow paging
A lowest level of security by most RDBMS is
What does new grouping sets enables you to do?
What are the types of joins?
0 Answers Tavant Technologies, Zensar,
How heap is implemented in database?
plz suggest me the book for preparation of NIC exam.
can anyone please tell what are the roles and responsibilities of a teradata developer in detail???
utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) LOAD B) REORG C) COPY D) EXPLAIN
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
What is database server and how it works?
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)