Search
 
SCRIPT & CODE EXAMPLE
 

SQL

where condition in mongodb

-- mongodb : 
db.people.find(
    { status: "A" }
)
--sql
SELECT *
FROM people
WHERE status = "A"
-- mongodb 
db.people.find(
    { status: "A" },
    { user_id: 1, status: 1, _id: 0 }
)
-- sql
SELECT user_id, status
FROM people
WHERE status = "A"
Comment

PREVIOUS NEXT
Code Example
Sql :: oracle sql for each row 
Sql :: how to get previous year from sysdate in oracle 
Sql :: postgresql in array 
Sql :: python mysql create table if not exists 
Sql :: grant all privileges database postgres to user 
Sql :: ORA-01090: shutdown in progress - connection is not permitted 
Sql :: get triggers by query 
Sql :: mac django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module. Did you install mysqlclient? 
Sql :: oracle sql generate list of days 
Sql :: warning: mysqli::__construct(): (hy000/2002): 
Sql :: TSQL function split string 
Sql :: if null put 0 sql 
Sql :: uncheck constraints and delete from table 
Sql :: Which MySQL data type to use for storing boolean values 
Sql :: sql count more than 1 
Sql :: how to define a save method in ruby for sql databases 
Sql :: oracle error line 
Sql :: convert rows into columns in oracle 
Sql :: sql datum formatieren 
Sql :: mysql regexp replace 
Sql :: php delete database 
Sql :: SQL SELECT TOP Equivalent in MySQL 
Sql :: power bi union columns 
Sql :: how to convert external table to managed table in hive 
Sql :: mysql group by 
Sql :: fk in insert mysql 
Sql :: date less than in sql 
Sql :: how to get table id sequence postgres 
Sql :: sql select data type of query 
Sql :: changing name of column and datatype in sql 
ADD CONTENT
Topic
Content
Source link
Name
8+9 =