Sort 12 Discussions, By:
Please Login in order to post a comment
This link explains clearly what is that symbol. FYI
Answer is: 2
Where, σ represents the Select Predicate, r is the name of relation(table name in which you want to look for data), and p is the prepositional logic, where we specify the conditions that must be satisfied by the data. In prepositional logic, one can use unary and binary operators like =, <, > etc, to specify the conditions.
It must return 2.
so the answer is 2
I dont understand what this is asking
This might help:
condition is a boolean expression in which rows are selected for which the condition is true
rows are going vertically since they are asking for the number >3000 and the student name it should give you 2 rows
The condition is number < 3000, just in case someone gets confused.
What is the count of rows returned in the following relational selection?