Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Multiple column Queries:
Syntax:
SELECT COLUMN1, COL2,......
FROM TABLE
WHERE (COLUMN1, COL2, ...) IN
(SELECT COLUMN1, COL2,....
WHERE );
Example: Find the department number, name, job title and salary of those people who have the similar job title and salary as those are in department 10.
SELECT DEPTNO,ENAME, JOB, SAL
FROM EMP
WHERE (JOB, SAL) IN ( SELECT JOB, SAL
WHERE DEPTNO=10);
OUTPUT:
DEPTNO
ENAME
JOB
SAL
10
Nirmal
MANAGER
2975
Kailash
ANALYST
3000
20
Ashwin
growing phase and shrinking phase are disjoint, why ?
What is a SELECT operation? The select operation selects tuples that please a given predicate. We use the lowercase letter σ to denote selection.
Data Warehousing & Mining 1. What is the concept of knowledge discovery in database? 2. Describe the following types of Multidimensional Data Models. • Stars, Snowflakes and
Why is database design important?
Difference between Operating System and Database Security Security within the operating system can be executed at various levels ranging from passwords for access to system, t
Emergence of Client Server Architecture Some of the pioneering work that was completed by some of the relational database vendors permitted the computing to be distributed on m
Consider the following relational scheme: R (a,b,c,d,e,f) and its corresponding set of FDs {d→ a, be → c, ac → e, b → f, f → d, a → c}. a. Is the following decomposition i) non
In E-R Diagram how derived attribute are represented ? In E-R Diagram By Dashed ellipse derived attribute are represented.
composite attribute
Identification of concurrency Identification of concurrency: Dynamic model identifies concurrency. Two objects are said to be parallel (concurrent) if they can receive events a
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd