could u plz explain about joins and views?
Answers were Sorted based on User's Feedback
Answer / vimal
VIEWS
View is a virtual table
If we want to access specific column from specific table we
can go for views
JOINS
Sometimes we have to select data from two or more tables to
make our result complete we have to perform join
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mohsin mohammed abdul
basically we use joins to query a sql with 1 or more tables.
1) self join.. join within the same table using aliases
2) equi join.. join between the 2 tables with commom columns
3) outer join.. and it is divided into 2 catagories left
outer join and right outer join.
View :- its a logical representation of one or more tables.
View doesn't have the data of its own. But still you can
perform DML on a view ..the changes will be done in the
underlying base tables..
Is This Answer Correct ? | 1 Yes | 0 No |
Do you know what are the steps to process a single select statement?
What is 3nf normalization?
What is dataset and its uses
What are the database objects? : SQL Server Architecture
What does man by sql wildcard characters in sql server?
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?
What is difference between TRUNCATE and DELETE statement
Who developed sql server?
What is a deadlock and what is a live lock?
What is the recommended total size of your memory optimized tables?
Why we are using the sql language?. What is the purpose of using this?
Magic Tables ?