Use of COUNT in SQL

It describes and discusses various general methods of expressing constraints, eventually noting that support for "=" with relation operands is sufficient for completeness. It also notes that every constraint can be expressed as an invocation of IS_EMPTY, where IS_EMPTY(r) is equivalent to r { } = TABLE_DUM. First, though, it gives Example, showing how to use COUNT to test a relation for emptiness. Example here is a direct translation of that one into SQL.

Example: Testing for absence of counterexamples.

CREATE ASSERTION Must_be_enrolled_to_take_exam

CHECK ((SELECT COUNT (*)

FROM EXAM_MARK

WHERE (Student_Id, CourseId ) NOT IN

(SELECT Student_Id, CourseId

FROM IS_ENROLLED_ON ) )

= 0);

Posted Date: 1/18/2013 7:26:01 AM | Location : United States

Ask an Expert

Related Discussions:- Use of count in sql, Assignment Help, Ask Question on Use of count in sql, Get Answer, Expert's Help, Use of count in sql Discussions

Write discussion on Use of count in sql
Your posts are moderated

Write your message here..

Related Questions

Rownum - sql pseudocolumns, ROWNUM The ROWNUM returns a number represe... ROWNUM The ROWNUM returns a number representing the order in which a row was selected from the table. The first row selected has a ROWNUM of 1; the second row has a ROWNUM of

Deleting objects in pl sql, Deleting Objects You can use the DELETE st... Deleting Objects You can use the DELETE statement to eradicate objects from an object table. To eradicate objects selectively, you use the WHERE clause, as shown below: BEG

Testing triggers, Demonstrate your knowledge of PL/SQL programming by writi... Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

Dbms, DBMS: The answer to this question is of course given in of the t... DBMS: The answer to this question is of course given in of the theory book. This book is concerned with SQL DBMSs and SQL databases in particular. Soon we will be looking a

Using not null-declarations in sql, Using NOT NULL Besides assigning an ... Using NOT NULL Besides assigning an initial value, the declarations can impose the NOT NULL constraint, as the example below shows: acct_id INTEGER(4) NOT NULL := 9999; You ca

Use the returning clause -improve performance of application, Use the RETUR... Use the RETURNING Clause Frequently, the application requires information about the row affected by a SQL operation, for illustration, to produce a report or take a subsequent

Usefulness of data type, Usefulness of Data Type In SQL, as in most c... Usefulness of Data Type In SQL, as in most computer languages, a type can be used for constraining the values that are permitted to be used for some purpose. In particular, i

Do you know anyone that can do this type of coding or not?, Task 2 [12 mark... Task 2 [12 marks] Write the package body for the following package specification (the detailed description of each function and procedure is provided in the appendix below). Place

Delimiters, Delimiters A delimiter is a simple or compound symbol whi... Delimiters A delimiter is a simple or compound symbol which has a special meaning to PL/SQL. For example, you use delimiters to symbolize an arithmetic operation like additio

Biconditional - sql, Biconditional - SQL The biconditional p ↔ q can b... Biconditional - SQL The biconditional p ↔ q can be expressed in Tutorial D by p = q and the same is true of SQL. The question then arises as to whether, in SQL, p = q is equiv