Select Operation

Applied Sciences | Free Full-Text | Performance Analysis of NoSQL and  Relational Databases with CouchDB and MySQL for Application's Data Storage  | HTML

• Takes rows from one table to create a new
table
– Specify the table from which rows are to be taken,
and the test for selection
– Syntax: Select Test From Table
• Test is a formula combining attribute names, constants,
and relational operators
– Test is applied to each rows of the table to
determine if it should be included in result table
• If the test is true for a given row, the row is included in the
result table; otherwise it is ignored
Select Interest=’Beach’ From Nations.