{"id":16780,"date":"2018-05-27T07:10:57","date_gmt":"2018-05-27T07:10:57","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=16780"},"modified":"2021-04-05T13:45:31","modified_gmt":"2021-04-05T08:15:31","slug":"cql-clauses","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/cql-clauses\/","title":{"rendered":"CQL Clauses – Select, Where, OrderBy Clauses in Cassandra"},"content":{"rendered":"

1. Objective<\/h2>\n

In this Cassandra Tutorial<\/a><\/strong>, we will discuss the CQL clauses that are used along with different commands. CQL clauses are used to specify data that has to be used in a program or application. <\/span><\/p>\n

A user can select a column data and perform any operation using other CQL commands. <\/span>
\nSo, let’s begin CQL Clauses.<\/span><\/p>\n

\"CQL<\/a>

CQL Clauses – Select, Where, OrderBy Clauses<\/p><\/div>\n

Do you know top Cassandra Features<\/a><\/strong><\/p>\n

2. CQL Clauses<\/h2>\n

Cassandra Query Langauge (CQL), has three major types of clauses, let’s discuss them one by one:<\/p>\n

a. SELECT Clause<\/span><\/h3>\n

There are some programs that have to use a specific data from a table. In such programs, the user has to derive a particular set of data. The user can use a SELECT keyword to use a particular field in a table.<\/span>
\nLet’s See How Cassandra Stores Data or\u00a0Cassandra Data Model<\/a><\/strong>
\nA syntax of SELECT Clause:<\/strong> <\/span><\/p>\n

SELECT <identifier> FROM <table name>;<\/pre>\n
In the syntax, the identifier is basically a field that has to be selected from a particular table. If the identifier is ‘*’, it means the user will select the whole table.<\/span><\/p>\n
Example:<\/strong> In this example, we will first select a particular field from the table below. And in next set, we will select the whole table.<\/span>
\nTable.1 CQL Clauses – SELECT Clause<\/strong><\/p>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n
 
Id<\/b><\/span><\/td>\nName<\/b><\/span><\/td>\nBranch<\/b><\/span><\/td>\nPhone number<\/b><\/span><\/td>\n<\/tr>\n
001<\/span><\/td>\nAyush<\/span><\/td>\nElectrical Engineering<\/span><\/td>\n9877656543<\/span><\/td>\n<\/tr>\n
002<\/span><\/td>\nAaron<\/span><\/td>\nComputer Engineering<\/span><\/td>\n9867767689<\/span><\/td>\n<\/tr>\n
003<\/span><\/td>\nKabir<\/span><\/td>\nApplied Physics<\/span><\/td>\n8769878762<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
First, we will select the field ‘Branch’.<\/span><\/p>\n
cqlsh; keyspace1> SELECT Branch FROM student;<\/pre>\n
Now, to select the full table, the code is,<\/span><\/p>\n
cqlsh;keyspace1> SELECT Branch FROM student;<\/pre>\n
Let’s Learn Architecture of\u00a0Cassandra in Detail<\/a><\/strong><\/p>\n
b. WHERE\u00a0<\/span>Clause<\/span><\/h3>\n
WHERE clause is a bit more specific than SELECT. In SELECT the user selects a field, whereas in WHERE clause the user can select a particular data. <\/span><\/p>\n
In other words, the data is specific to a particular cell of a table. This clause is used along with SELECT cause, in which WHERE acts as a condition.<\/span>
\nA Syntax of WHERE Clause:<\/strong><\/span><\/p>\n
SELECT<field name>FROM<table name>WHERE<identifier>;<\/pre>\n
Example:<\/strong> In this example, we will select a particular cell ‘Computer Engineering’ from the previous table. And in the next set, we will select a whole row of a table by using ‘*’.<\/span><\/p>\n
cqlsh;keyspace1> SELECT Branch FROM student WHERE Id=002;<\/pre>\n
Now to select the whole row;<\/span><\/p>\n
cqlsh;keyspace1>SELECT * FROM student WHERE Id=002;<\/pre>\n
Do you know Cassandra Curd Operation \u2013 Create, Update, Read & Delete<\/a><\/strong><\/p>\n
c. ORDERBY Clause<\/span><\/h3>\n
There are applications that require a particular set of data in a particular set of order. To perform this operation the user can use ORDERBY clause along with SELECT clause.<\/span>
\nA Syntax of ORDERBY Clause:<\/strong><\/span><\/p>\n
SELECT<field name>FROM<table name>ORDERBY<identifier>;<\/pre>\n
Example:<\/strong> In this example, we will arrange the table according to a phone number.<\/span><\/p>\n
cqlsh;keyspace1> SELECT*FROM student ORDERBY Phone number;<\/pre>\n
Have a look at Cassandra Data Definition Command<\/a><\/strong><\/p>\n
So, this was all about CQL Clauses Tutorial. Hope you like our explanation.<\/p>\n
3. Conclusion<\/h2>\n
Hence, in this Cassandra Query Language\u00a0Clauses Tutorial, we discussed CQL CLAUSES: SELECT Clause, WHERE Clause & ORDERBY\u00a0Clause with examples and syntax. <\/span><\/p>\n
Furthermore, if have any doubt regarding CQL commands, feel free to ask in the comment section. <\/span>
\nRelated Topic – Cassandra Interview Questions<\/a><\/strong><\/span>
\n For reference<\/a><\/strong><\/span>
1. Objective In this Cassandra Tutorial, we will discuss the CQL clauses that are used along with different commands. CQL clauses are used to specify data that has to be used in a program...<\/p>\n","protected":false},"author":7,"featured_media":16790,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[2326,2558,2559,3023,9329,12699],"class_list":["post-16780","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cassandra","tag-cassandra-clauses","tag-clauses-in-cassandra","tag-clauses-in-cql","tag-cql-clauses","tag-orderby-clause","tag-select-clause"],"yoast_head":"\nCQL Clauses - Select, Where, OrderBy Clauses in Cassandra - DataFlair<\/title>\n<meta name=\"description\" content=\"CQL Clauses- Cassandra Clauses, CQL Select clause, CQL Where clause, CQL orderby clause with syntax and examples, Cassandra Query Language Clauses\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/cql-clauses\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CQL Clauses - Select, Where, OrderBy Clauses in Cassandra - DataFlair\" \/>\n<meta property=\"og:description\" content=\"CQL Clauses- Cassandra Clauses, CQL Select clause, CQL Where clause, CQL orderby clause with syntax and examples, Cassandra Query Language Clauses\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/cql-clauses\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-27T07:10:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-05T08:15:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-CLAUSES-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CQL Clauses - Select, Where, OrderBy Clauses in Cassandra - DataFlair","description":"CQL Clauses- Cassandra Clauses, CQL Select clause, CQL Where clause, CQL orderby clause with syntax and examples, Cassandra Query Language Clauses","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/cql-clauses\/","og_locale":"en_US","og_type":"article","og_title":"CQL Clauses - Select, Where, OrderBy Clauses in Cassandra - DataFlair","og_description":"CQL Clauses- Cassandra Clauses, CQL Select clause, CQL Where clause, CQL orderby clause with syntax and examples, Cassandra Query Language Clauses","og_url":"https:\/\/data-flair.training\/blogs\/cql-clauses\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-05-27T07:10:57+00:00","article_modified_time":"2021-04-05T08:15:31+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-CLAUSES-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/cql-clauses\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/cql-clauses\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/beb0cab24b7aa54423a3b50e669a9dcd"},"headline":"CQL Clauses – Select, Where, OrderBy Clauses in Cassandra","datePublished":"2018-05-27T07:10:57+00:00","dateModified":"2021-04-05T08:15:31+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/cql-clauses\/"},"wordCount":499,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/cql-clauses\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-CLAUSES-01.jpg","keywords":["Cassandra Clauses","Clauses in Cassandra","Clauses in CQL","CQL Clauses","ORDERBY Clause","SELECT Clause"],"articleSection":["Cassandra Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/cql-clauses\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/cql-clauses\/","url":"https:\/\/data-flair.training\/blogs\/cql-clauses\/","name":"CQL Clauses - Select, Where, OrderBy Clauses in Cassandra - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/cql-clauses\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/cql-clauses\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-CLAUSES-01.jpg","datePublished":"2018-05-27T07:10:57+00:00","dateModified":"2021-04-05T08:15:31+00:00","description":"CQL Clauses- Cassandra Clauses, CQL Select clause, CQL Where clause, CQL orderby clause with syntax and examples, Cassandra Query Language Clauses","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/cql-clauses\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/cql-clauses\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/cql-clauses\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-CLAUSES-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-CLAUSES-01.jpg","width":1200,"height":628,"caption":"CQL Clauses - Select, Where, OrderBy Clauses"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/cql-clauses\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Cassandra Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/cassandra\/"},{"@type":"ListItem","position":3,"name":"CQL Clauses – Select, Where, OrderBy Clauses in Cassandra"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/beb0cab24b7aa54423a3b50e669a9dcd","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team specializes in creating clear, actionable content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Backed by industry expertise, we make learning easy and career-oriented for beginners and pros alike.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam3\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/16780","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=16780"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/16780\/revisions"}],"predecessor-version":[{"id":90511,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/16780\/revisions\/90511"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/16790"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=16780"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=16780"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=16780"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}