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.
- 0 Answers
- 1388 Views
- Amazon, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
What is a database string?
WHAT IS OPM?(IN DETAILED)
Define stored procedure?
What is a database call?
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
Explain the table term used in database.
what is tkprof tool and how it is used???
How does non-cluster index functions?
How can we join three tables in SQL server 2000
How do you pass parameter in stored procedure?
What is the difference between a stored procedure and a query?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
