SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES
Answer / durgaprasad
Create View emp_dept_vw with encryption as
select emp.empid,emp.ename,dept.deptid,dept.dname
from emp,dept where emp.deptid=dept.deptid
with check option
| Is This Answer Correct ? | 6 Yes | 0 No |
write the query for find the top 2 highest salary in sql server
36 Answers Cranes, Jayanti Software, Medi Assist, Rmax, TCS,
Explain about temporary stored procedure?
What is faster join or union?
Explain following error properties?
What is the main purpose of having conversation group?
What are the types of normalization?
Call by value and call by reference in procedure and function, with NOCOPY.
What is the concept of optimization?
Benefits of Stored Procedures?
How to execute a sql statement using odbc_exec()?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What is the difference between NOROW and LOCKROW?
0 Answers Accenture, Honeywell, Satyam,
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)