Difference between revisions of "Select"

From wikieduonline
Jump to navigation Jump to search
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
{{lowercase}}
 
{{lowercase}}
 +
select
 +
[[select count]]
 +
[[select distinct]]
  
  
[[PostgreSQL]]:
+
[[PostgreSQL select]]:
* <code> select * from your_table_name</code>
+
* <code> select * from your_table_name;</code>
 +
 
 +
* <code> select * from your_db.your_table_name;</code>
  
 
  SELECT * FROM your_table_name;
 
  SELECT * FROM your_table_name;
Line 17: Line 22:
  
 
* <code>[[jq]] '.[] | [[select]](.color=="blue")' your_json_file.json</code>
 
* <code>[[jq]] '.[] | [[select]](.color=="blue")' your_json_file.json</code>
 +
 +
  
 
== Related terms ==
 
== Related terms ==
 
* [[MongoDB]]: <code>db.YOUR_COLLETION_NAME.[[find]] ()</code>
 
* [[MongoDB]]: <code>db.YOUR_COLLETION_NAME.[[find]] ()</code>
 
* <code>[[select count]]</code>
 
* <code>[[select count]]</code>
 +
* <code>[[select distinct]]</code>
 
* <code>[[GRANT SELECT]]</code>
 
* <code>[[GRANT SELECT]]</code>
* <code>[[select distinct]]</code>
+
* <code>[[ERROR: permission denied for relation]] your_table</code>
  
 
== See also ==
 
== See also ==

Revision as of 13:48, 8 November 2022

Advertising: