What are joins..how many types of joins are there?
Answer Posted / akn
In SQL Server,Join actually puts data from two or more
tables into a sinle result set.
there are 3 types of joins
1.Inner join
2.Outer join
3.Cross join
| Is This Answer Correct ? | 73 Yes | 40 No |
Post New Answer View All Answers
Difference between the “verify” and “feedback” command?
Why should I use oracle database?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Can we write insert statement in function in oracle?
What is null value in oracle?
What is system tablespace?
What is the difference between "as" and "is" in an oracle stored procedure?
How to rollback the current transaction in oracle?
What is materialized view in Oracle?
How to call a stored function in oracle?
What happens if recursive calls get out of control?
How to assign data of the deleted row to variables?
How to specify default values in insert statement using oracle?
How to login to the server without an instance?