Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

full outer join syntax

Answer Posted / madhav

Full outer join

select e.empno,e.ename,e.deptno,e.sal,d.deptno,d.dname from
emp e full outer join dept d
on e.deptno=d.deptno;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Advantages and disadvantages of stored procedure?

1123


What is sap sql?

989


Mention what is the function that is used to transfer a pl/sql table log to a database table?

997


How do you delete a table?

1083


Explain two easy sql optimizations.

1019


Can sql function call stored procedure?

1028


When you have to use a default "rollback to" savepoint of plvlog?

1204


Explain the order of sql statement execution?

1049


What is the difference between truncate and drop statements?

1195


what is the bond code in materialized view?

3005


What are joins in sql?

1050


What is mutating sql table?

1117


Can we insert data into view?

909


How do you use a while loop in pl sql?

1016


Why is nosql good?

1032