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 the full procedure for using store procedure in informatica7.1?
Explain transaction manager?
sparse lookup and where its options we find in OCI and db2?
How do I manually create a database?
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
What are the types of joins?
0 Answers Tavant Technologies, Zensar,
Explain buffer manager?
What is the use of default key?
What is ole db provider for sql server?
define primary key index, bitmap index, hash index,virtual indwx
Differentiate between unique key and foreign key?
how do you do sql tuning?
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)