Difference between revisions of "Select"

Latest revision as of 14:20, 22 May 2024

select 
select count
select distinct

SELECT * FROM your_table_name;
ERROR: permission denied for table your_table_name

jq '.[] | select(.color=="blue")' your_json_file.json
cat file.txt | jq '.Quotas[] | select(.QuotaName | contains("G and VT")) | {QuotaName, Value, QuotaArn, QuotaCode, Unit}'

@@ Line 1: / Line 1: @@
+{{lowercase}}
+ select
+ [[select count]]
+ [[select distinct]]
+[[PostgreSQL select|PostgreSQL]]:
+* <code> select * from your_table_name;</code>
+* <code> select * from your_db.your_table_name;</code>
+* <code>[[SELECT * FROM pg_stat_activity;]]</code>
+* <code>[[SELECT version();]]</code>
+* <code>[[SELECT current user;]]</code>
+* <code>[[SELECT current database();]]</code>
+ SELECT * FROM your_table_name;
+ [[ERROR: permission denied for table]] your_table_name
+* <code>[[select]] current_setting('[[block_size]]');</code>
+* [[MySQL]]: <code>[[select user]] FROM [[mysql.user]];</code>
+[[jq]]:
 * <code>[[jq]] '.[] | [[select]](.color=="blue")' your_json_file.json</code>
-* <code> select * from TABLE_NAME</code> ([[SQL]])
+* <code>cat file.txt | jq '.Quotas[] | select(.QuotaName | [[contains]]("G and VT")) | {QuotaName, Value, QuotaArn, QuotaCode, Unit}'</code>
-* <code>[[select]] current_setting('[[block_size]]');</code>
 == Related terms ==
 * [[MongoDB]]: <code>db.YOUR_COLLETION_NAME.[[find]] ()</code>
 * <code>[[select count]]</code>
+* <code>[[select distinct]]</code>
+* <code>[[GRANT SELECT]]</code>
+**<code>[[GRANT SELECT ON ALL TABLES]]</code>
+* <code>[[ERROR: permission denied for relation]] your_table</code>
+* [[SELECT can cause synchronous writes on the disk]]
 == See also ==
+* {{SELECT}}
 * {{SQL}}
 [[Category:Computing]]