Grokking the Advanced System Design Interview
Ask Author
Back to course home

0% completed

Vote For New Content
"while querying, we cannot add any column in the where clause other than the pri...

Amey Naik

Sep 22, 2021

"while querying, we cannot add any column in the where clause other than the primary key."

0

0

Comments
Comments
A
Amey Naik4 years ago

Can someone give an example for this please?

Design Gurus
Design Gurus4 years ago

Take the example of an employee table with columns: employee_id (primary key), name, city.

In NoSQL, we can't write a where clause like:

'Select * from employee Where city = 'New York'

On this page