题解 | #查询所有列#
查询所有列
https://www.nowcoder.com/practice/f9f82607cac44099a77154a80266234a
--方法1:横向,加载消耗带宽低
SELECT id, device_id, gender, age, university, province from user_profile;
--方法2:全选符,但是比较消耗带宽
SELECT * FROM user_profile;
--不同的书写方式1
SELECT
id,
device_id,
gender,
age,
university,
province
FROM
user_profile;
--不同的书写方式2
Select *
From user_profile;
#SQL练习#

