what is a join? what are the types of joins?
- 5 Answers
- 8359 Views
- HCL, Satyam, I also Faced
- E-Mail Answers
Answer Posted / m m naidu
JOIN: A join is a query using which we can query data from
more than one table
TYPES OF JOINS:
1.EQUI JOIN
2.SELF JOIN
3.OUTER JOIN
a.left outer join
b.right outer join
c.full outer join
4.cartesian join
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
What is a Datastore in Cognos?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
Can you define a catalog and types of catalogs in cognos?
What is main advantage datawarehousing over oracle?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
What is defined as data mining?
What are slice and dice?
Explain is there any comparison available for cognos reportnet vs crystal reports?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
How to publish a package by running Java Script?
What are the themes in a data warehouse?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
-----------Diff b/w OLAP and RDBMS?
