Answer Posted / 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 |
Post New Answer View All Answers
Differentiate between delete and truncate.
What is policy management?
What is a mixed extent?
What happens if null values are involved in bitwise operations?
How to create a new schema in a database?
Tell me about normalization in DBMS.
What is collation sensitivity? Explain different types.
What does man by sql wildcard characters in sql server?
What is a group function explain with an example?
What is a filestream?
What are the steps to process a single select statement?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What is meant by indexing files?
last function used in MS Access to convert sql what function will use in sql
How to modify an existing stored procedure in ms sql server?