could u plz explain about joins and views?
- 2 Answers
- 4480 Views
- I also Faced
- E-Mail Answers
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 |
How to compare the top two records using sql?
How to list all columns in a table using odbc_columns()?
What are the differences between char and nchar in ms sql server?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How you can move data or databases between servers and databases in sql server?
Explain powershell included in sql server 2008?
What are secondary xml indexes?
What are the different sql server versions?
What is 1nf 2nf?
Can we insert data if clustered index is disabled?
What is an indice?
How to generate create view script on an existing view?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
