Cassandra READ Data
SELECT command is used to read data from Cassandra table. You can use this command to read a whole table, a single column, a particular cell etc.
Syntax:
SELECT FROM <tablename>
Example:
Let’s take an example to demonstrate how to read data from Cassandra table. We have a table named “student” with columns (student_id, student_fees student_name)
Read the whole table using SELECT command
SELECT * FROM student;
Read Particular Columns
This example will read only student_name and student_id from the student table.
SELECT student_id, student_name FROM student;
Use of WHERE Clause
WHERE clause is used with SELECT command to specify the exact location from where we have to fetch data.
How to find Nth Highest Salary in SQL
Syntax:
SELECT FROM
WHERE ;Note: WHERE clause can be used only on the columns that are a part of primary key or have a secondary index on them.
Example:
SELECT * FROM student WHERE student_id=2;
