Basic SQL Queries
give me all basic sql query question with ans syntax
Here’s a comprehensive list of basic SQL query questions with answers and syntax examples:
1. Retrieve All Data from a Table
Question: How do you select all columns from a table?
Syntax:
sql
SELECT * FROM table_name;
2. Select Specific Columns
Question: How do you select specific columns?
Syntax:
sql
SELECT column1, column2 FROM table_name;
3. Filter Data Using WHERE Clause
Question: How do you filter rows based on a condition?
Syntax:
sql
SELECT * FROM table_name WHERE column_name = value;
4. Filter with Multiple Conditions
Question: How do you filter rows with multiple conditions?
Syntax:
Printed using ChatGPT to PDF, powered by PDFCrowd HTML to PDF API. 1/6
sql
-- Using AND
SELECT * FROM table_name WHERE column1 = value1 AND column2 = value2;
-- Using OR
SELECT * FROM table_name WHERE column1 = value1 OR column2 = value2;
5. Order Data
Question: How do you sort results?
Syntax:
sql
-- Ascending order (default)
SELECT * FROM table_name ORDER BY column_name;
-- Descending order
SELECT * FROM table_name ORDER BY column_name DESC;
6. Limit the Number of Rows
Question: How do you limit the number of rows returned?
Syntax:
sql
SELECT * FROM table_name LIMIT number_of_rows;
7. Use Aggregate Functions
Question: How do you perform calculations on column values?
Syntax:
sql
-- Count rows
SELECT COUNT(*) FROM table_name;
-- Sum values
SELECT SUM(column_name) FROM table_name;
-- Average
SELECT AVG(column_name) FROM table_name;
-- Maximum and Minimum
SELECT MAX(column_name), MIN(column_name) FROM table_name;
Printed using ChatGPT to PDF, powered by PDFCrowd HTML to PDF API. 2/6
8. Group Data
Question: How do you group rows with the same value?
Syntax:
sql
SELECT column_name, COUNT(*)
FROM table_name
GROUP BY column_name;
9. Filter Groups Using HAVING
Question: How do you filter grouped data?
Syntax:
sql
SELECT column_name, COUNT(*)
FROM table_name
GROUP BY column_name
HAVING COUNT(*) > value;
10. Insert Data
Question: How do you add new rows to a table?
Syntax:
sql
INSERT INTO table_name (column1, column2)
VALUES (value1, value2);
11. Update Data
Question: How do you update existing rows?
Syntax:
sql
UPDATE table_name
SET column1 = value1, column2 = value2
WHERE condition;
12. Delete Data
Printed using ChatGPT to PDF, powered by PDFCrowd HTML to PDF API. 3/6
Question: How do you delete rows from a table?
Syntax:
sql
DELETE FROM table_name WHERE condition;
13. Use Aliases
Question: How do you create temporary names for columns or tables?
Syntax:
sql
SELECT column_name AS alias_name
FROM table_name;
14. Join Tables
Question: How do you combine rows from two tables?
Syntax:
sql
-- Inner Join
SELECT a.column1, b.column2
FROM table1 a
INNER JOIN table2 b
ON a.common_column = b.common_column;
-- Left Join
SELECT a.column1, b.column2
FROM table1 a
LEFT JOIN table2 b
ON a.common_column = b.common_column;
-- Right Join
SELECT a.column1, b.column2
FROM table1 a
RIGHT JOIN table2 b
ON a.common_column = b.common_column;
-- Full Outer Join
SELECT a.column1, b.column2
FROM table1 a
FULL OUTER JOIN table2 b
ON a.common_column = b.common_column;
15. Find Unique Values
Question: How do you find unique records?
Syntax:
Printed using ChatGPT to PDF, powered by PDFCrowd HTML to PDF API. 4/6
sql
SELECT DISTINCT column_name
FROM table_name;
16. Use Subqueries
Question: How do you use a query within another query?
Syntax:
sql
SELECT column_name
FROM table_name
WHERE column_name IN (SELECT column_name FROM another_table);
17. Create a Table
Question: How do you create a new table?
Syntax:
sql
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype
);
18. Delete a Table
Question: How do you delete a table?
Syntax:
sql
DROP TABLE table_name;
19. Alter a Table
Question: How do you modify a table's structure?
Syntax:
Printed using ChatGPT to PDF, powered by PDFCrowd HTML to PDF API. 5/6
sql
-- Add a column
ALTER TABLE table_name ADD column_name datatype;
-- Drop a column
ALTER TABLE table_name DROP COLUMN column_name;
-- Modify a column
ALTER TABLE table_name MODIFY COLUMN column_name datatype;
20. Create Index
Question: How do you create an index to improve query performance?
Syntax:
sql
CREATE INDEX index_name ON table_name (column_name);
These questions and syntax examples cover the basics of SQL and help build a strong foundation. Let
me know if you'd like to dive deeper into any topic!
Printed using ChatGPT to PDF, powered by PDFCrowd HTML to PDF API. 6/6