← 返回 netflix 的题目列表SQL Query to Retrieve User IDs and Names from Users Table
类型:online_judge
netflix
Second Question
Suppose you have a users table with fields id and name. Write a simple SQL query to return all users' id and name.
Input Format:
users table
Output Format:
Users' id and name.
Example:
Given the table:
| id | name | |-----|-------| | 1 | Alice | | 2 | Bob |
The query should return:
| id | name | |-----|-------| | 1 | Alice | | 2 | Bob |
Example
Input
users with rows (id=1, name='Alice') and (id=2, name='Bob')