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!
Aggregate functions
Example: Find the total number of employees.
SELECT COUNT (*) FROM EMP;
Example: //Find the minimum, maximum and average salaries of employees of department D1//.
SELECT MIN(SAL), MAX (SAL), AVG(SAL) FROM EMP
WHERE DEPTNO = 'D1' ;
What is Primary key? Primary Key - Primary key is one of the candidate keys which uniquely identifies each row in the relation.
(a) What is a Sub-Query? (b) What is the difference between a scalar sub-query and a tabular sub-query? (c) Write an equivalent SQL statement to get the Name of Product wh
In an E-R diagram how attributes are represented ? In an E-R diagram attributes are represented in a ellipse.
Answer SQL Queries to extract data from data tables and questions on mapping conceptual data models into relational data model.
Explain Alternate key? Alternate Key - All the candidate keys except primary key are known as alternate keys.
What is the State Machine Engine The straightest approach to implement control is to have any way of explicitly representing and executing state machines. With the help of thi
1. Use the Invoice table structure shown below to answer the following questions: a) Draw the dependency diagram and identify the primary key and all dependencies, including al
What are the advantages of object ID? The main advantages of Object IDs are as below: i) IDs are not changing ii) IDs are completely independent of the changes in data v
Define the Query optimisation The query parser commonly generates a standard initial tree to correspond to an SQL query, with no doing any optimization. Such type of a canonica
What is difference between TRUNCATE and DELETE? - Truncate can't be rolled back whereas Delete can be. - Truncate keeps the lock on table whereas Delete keeps the lock on ea
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: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd