# SQL - Fundamentals (Data Analytics) > SELECT, FROM, WHERE, ORDER BY, LIMIT, comparison operators, LIKE, IN, BETWEEN, NULL - 25 interview questions - Junior - [Interview Questions: Data Analytics](https://sharpskill.dev/en/technologies/data-analytics/interview-questions.md) ## 1. Which SQL keyword is used to retrieve data from a table? **Answer** SELECT is the fundamental SQL keyword for querying and retrieving data from one or more tables. It forms the basis of every read query in SQL and is always followed by the desired columns or the asterisk (*) to select all available columns. ## 2. Which SQL keyword specifies the table to search data from? **Answer** FROM indicates the source table in an SQL query. It always follows SELECT and precedes filtering clauses like WHERE. Without FROM, the query does not know which table to search for the requested data. ## 3. What does the query SELECT * FROM clients return? **Answer** The asterisk (*) is a shortcut meaning "all columns". Combined with FROM clients, the query returns all columns and all rows from the clients table. This is useful for exploring a table but discouraged in production as it may return unnecessary data and slow down performance. ## 22 more questions available - Which keyword is used to filter rows returned by an SQL query? - What is the correct order of clauses in a basic SQL query? Sign up for free: https://sharpskill.dev/en/login ## Other Data Analytics interview topics - [Google Sheets - Fundamentals](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/google-sheets-basics.md): 20 questions, Junior - [Google Sheets - Advanced Formulas](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/google-sheets-advanced.md): 20 questions, Junior - [SQL - Aggregations and Grouping](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/sql-aggregations.md): 20 questions, Junior - [SQL - Joins](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/sql-joins.md): 20 questions, Junior - [BigQuery - Fundamentals](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/bigquery-fundamentals.md): 20 questions, Junior - [Data Cleaning](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/data-cleaning.md): 20 questions, Junior - [KPIs and Business Metrics](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/kpis-metrics.md): 20 questions, Junior - [Descriptive Statistics](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/descriptive-statistics.md): 20 questions, Junior - [Zapier and No-Code Automation](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/zapier-automation.md): 20 questions, Junior - [Data Visualization Principles](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/data-viz-principles.md): 20 questions, Junior - [Python & Pandas - Fundamentals](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/python-pandas-basics.md): 20 questions, Junior - [Google Sheets - Automated Dashboards](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/google-sheets-dashboards.md): 20 questions, Mid-Level - [SQL - Subqueries and CTEs](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/sql-subqueries-ctes.md): 20 questions, Mid-Level - [SQL - Window Functions](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/sql-window-functions.md): 20 questions, Mid-Level - [BigQuery - Advanced Features](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/bigquery-advanced.md): 20 questions, Mid-Level - [Data Modeling](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/data-modeling.md): 20 questions, Mid-Level - [Funnel and Conversion Analysis](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/funnel-analysis.md): 20 questions, Mid-Level - [Cohort and Retention Analysis](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/cohort-retention.md): 20 questions, Mid-Level - [Google Tag Manager and Tracking](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/gtm-tracking.md): 20 questions, Mid-Level - [APIs and Webhooks](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/apis-webhooks.md): 20 questions, Mid-Level - [dbt - Fundamentals](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/dbt-fundamentals.md): 20 questions, Mid-Level - [AB Testing and Applied Statistics](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/ab-testing.md): 20 questions, Mid-Level - [Looker Studio (Google Data Studio)](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/looker-studio.md): 20 questions, Mid-Level - [Power BI - Fundamentals](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/power-bi-fundamentals.md): 20 questions, Mid-Level - [SQL - Advanced Analytical Queries](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/sql-advanced-analytics.md): 20 questions, Senior - [dbt - Advanced Features](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/dbt-advanced.md): 20 questions, Senior - [Power BI - DAX and Advanced Dashboards](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/power-bi-dax.md): 20 questions, Senior - [Python Analytics - Advanced Analysis and ML](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/python-analytics-advanced.md): 20 questions, Senior --- Source: SharpSkill (https://sharpskill.dev), tech interview preparation for your real stack. HTML version of this page: https://sharpskill.dev/en/technologies/data-analytics/interview-questions/sql-basics