There are several ways to select multiple rows and multiple columns from existing table. The possible syntaxes that to fetch multiple columns and rows from existing table are listed as below -

SELECT column1,column2, …, columnN
FROM table_name;   

• column1,column2 – Specifies the name of the columns used to fetch.
• table_name - Specifies the name of the table.

Let us consider below table(s) as an example table(s) to frame the SQL query for getting the desired results.

Scenario – Fetch all rows.

Requirement – Fetch all employees from employee_details table. The query was as follows -

SELECT * FROM employee_details; 

By executing above query, we can get results as shown below –

Scenario – Fetch specific columns with all row's information.

Requirement - Fetch employee details (emp_id, emp_name, designation) from employee_details table. The query was as follows -

SELECT emp_id, emp_name, designation FROM employee_details; 

By executing above query, we can get results as shown below –

Scenario – Fetch all rows that satisfies a condition.

Requirement - Fetch all employees those belongs to department 1000 from employee_details table. The query was as follows -

 SELECT * FROM employee_details WHERE dept_id = 1000; 

By executing above query, we can get results as shown below –

Scenario – Fetch unique designations using DISTINCT clause.

Requirement – Fetch unique designation from employee_details table. The query was as follows –

SELECT DISTINCT designation FROM employee_details; 

By executing above query, we can get results as shown below –

Scenario – Fetch specific column that satisfies the condition with AND operator.

Requirement – Fetch employee details(emp_id, emp_name, designation, dept_id) that belongs to department 1000 from employee_details table. The query was as follows -

SELECT emp_id, emp_name, designation, dept_id
FROM employee_details
WHERE dept_id = "1000" AND designation = "Analyst"; 

By executing above query, we can get results as shown below –

Scenario – Fetch all rows using IN operator.

Requirement – Fetch employees details those emp_id in 003, 004, 005 from employee_details table. The query was as follows -

SELECT * FROM employee_details WHERE emp_id IN (003, 004, 005); 

By executing above query, we can get results as shown below -