Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

could u plz explain about joins and views?

Question Posted / sarathraj

Answers were Sorted based on User's Feedback



could u plz explain about joins and views?..

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

could u plz explain about joins and views?..

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

Post New Answer

More SQL Server Interview Questions

What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  

What are pessimistic lock and optimistic lock?

0 Answers  

How to receive returning result from a query?

0 Answers  

What are the different ways of moving data/databases between servers and databases in SQL Server?

3 Answers   HCL,

Explain rdbms?

0 Answers  

What is Outter Join?

1 Answers  

What is the use of “join” in sql server?

0 Answers  

What are the general features of sql server management studio? : sql server management studio

0 Answers  

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

What types of integrity are enforced by a foreign-key constraint

1 Answers  

ow to bring suspect mode datbase online from scratch

0 Answers  

How does a profiler work?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories