What is a join and explain different types of joins?
Answer Posted / dhivya
Joins are used to fetch the records from more than one
table ,there are 4 types of joins
1.Equi-Join
2.Non-Equi-join
3.outer-join
4.Self-join
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
Which data type cannot be used as a parameter in a udf?
Explain about the storage and physical database design?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
How to customize error conditions.
explain detail about ftp in datastage?
fact table and dimension table containg one to many relationship or many to one relastionship
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
Explain about a primary key?
Explain about the hierarchical model of the database?
How is data stored in dbms?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
How to use timestamp datatypes
Explain the rollup operator?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?