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 |
Can group by and orderby be used together?
Can primary key be null?
Does partitioning ssd reduce performance?
Where views are stored in sql server?
Tell me what are the advantages of using stored procedures?
Do you know the isolation level that sql server support?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
How is foreign key related to primary key?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What is bit data type?
Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance