{"id":28269,"date":"2026-04-08T10:15:56","date_gmt":"2026-04-08T10:15:56","guid":{"rendered":"https:\/\/mycareernet.co\/blogs\/?p=28269"},"modified":"2026-04-08T09:31:29","modified_gmt":"2026-04-08T09:31:29","slug":"top-sql-interview-questions-and-answers-for-freshers","status":"publish","type":"post","link":"https:\/\/mycareernet.co\/blogs\/top-sql-interview-questions-and-answers-for-freshers\/","title":{"rendered":"Top SQL interview questions and answers for freshers in 2026"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"28269\" class=\"elementor elementor-28269\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2d4856d0 e-flex e-con-boxed e-con e-parent\" data-id=\"2d4856d0\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-476edd44 elementor-widget elementor-widget-text-editor\" data-id=\"476edd44\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;ekit_we_effect_on&quot;:&quot;none&quot;}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">If you think clearing SQL interview questions is about remembering syntax, interviews in 2026 will prove you wrong.<\/span><\/p><p><span style=\"font-weight: 400;\">Hiring teams are evaluating how you write a query, handle messy data, optimize query performance, and explain your thinking under pressure. Freshers who understand how data behaves inside relational database management systems consistently outperform those who rely on memorized answers.<\/span><\/p><p><span style=\"font-weight: 400;\">This guide breaks down the most relevant SQL interview questions for freshers, with practical explanations, real query patterns, and recruiter-backed insights that actually help you clear interviews.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-0c54d07 e-con-full e-flex e-con e-child\" data-id=\"0c54d07\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-676e810 elementor-widget elementor-widget-html\" data-id=\"676e810\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;ekit_we_effect_on&quot;:&quot;none&quot;}\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"toc-tabs\">\r\n    <h3>Table of Contents<\/h3>\r\n    \r\n    <a href=\"#basics\" class=\"toc-tab\">1. Basic SQL interview questions for freshers<\/a><br>\r\n    <a href=\"#core-concepts\" class=\"toc-tab\">2. Core SQL concepts every fresher must know<\/a><br>\r\n    <a href=\"#queries\" class=\"toc-tab\">3. SQL query-based interview questions<\/a><br>\r\n    <a href=\"#data-analyst\" class=\"toc-tab\">4. SQL interview questions for data analyst and entry-level roles<\/a><br>\r\n    <a href=\"#data-science\" class=\"toc-tab\">5. SQL interview questions for data science roles<\/a><br>\r\n    <a href=\"#mistakes\" class=\"toc-tab\">6. Common SQL interview mistakes<\/a><br>\r\n    <a href=\"#prep-tips\" class=\"toc-tab\">7. How to prepare for SQL interviews as a fresher<\/a><br>\r\n    <a href=\"#faq\" class=\"toc-tab\">8. Frequently asked questions<\/a><br>\r\n<\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8ed6792 e-flex e-con-boxed e-con e-parent\" data-id=\"8ed6792\" data-element_type=\"container\" data-e-type=\"container\" id=\"section1\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7946347 elementor-widget elementor-widget-html\" data-id=\"7946347\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;ekit_we_effect_on&quot;:&quot;none&quot;}\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<style>\r\n    \/* Improved Code block wrapper *\/\r\n    .mc-code-wrapper {\r\n        position: relative;\r\n        margin: 20px 0;\r\n        background-color: #f8fafc;\r\n        border: 1px solid #e2e8f0;\r\n        border-radius: 8px;\r\n        box-shadow: 0 2px 4px rgba(0,0,0,0.02);\r\n    }\r\n    \r\n    .mc-code-wrapper pre {\r\n        padding: 20px;\r\n        padding-right: 50px; \/* Space for the button *\/\r\n        margin: 0;\r\n        overflow-x: auto;\r\n        border: none;\r\n        background: transparent;\r\n    }\r\n\r\n    .mc-code-wrapper code {\r\n        font-family: 'Consolas', 'Monaco', 'Courier New', monospace;\r\n        font-size: 14px;\r\n        color: #334155;\r\n        line-height: 1.5;\r\n    }\r\n\r\n    \/* Icon-only Copy Button *\/\r\n    .mc-copy-btn {\r\n        position: absolute;\r\n        top: 12px;\r\n        right: 12px;\r\n        background-color: #ffffff;\r\n        color: #64748b;\r\n        border: 1px solid #e2e8f0;\r\n        border-radius: 6px;\r\n        padding: 8px;\r\n        cursor: pointer;\r\n        display: flex;\r\n        align-items: center;\r\n        justify-content: center;\r\n        transition: all 0.2s ease;\r\n        box-shadow: 0 1px 2px rgba(0,0,0,0.05);\r\n        z-index: 10;\r\n    }\r\n\r\n    .mc-copy-btn:hover {\r\n        background-color: #f1f5f9;\r\n        color: #0f172a;\r\n        border-color: #cbd5e1;\r\n    }\r\n\r\n    .mc-copy-btn svg {\r\n        width: 16px;\r\n        height: 16px;\r\n    }\r\n\r\n    \/* -----------------------------------------------------------\r\n        INSIGHT & TIP BOXES\r\n    ----------------------------------------------------------- *\/\r\n    .mc-insight-box {\r\n        background-color: #ffffff;\r\n        border: 1px solid #e2e8f0; \r\n        border-left: 6px solid #0288dc; \r\n        border-radius: 12px; \r\n        padding: 30px 32px; \r\n        margin: 35px 0;\r\n        box-shadow: 0 4px 6px -1px rgba(0, 0, 0, 0.05), 0 2px 4px -1px rgba(0, 0, 0, 0.03); \r\n    }\r\n    \r\n    .mc-insight-box h4 {\r\n        margin-top: 0;\r\n        margin-bottom: 16px;\r\n        font-size: 26px; \r\n        font-weight: 500;\r\n        color: #0f172a;\r\n        display: flex;\r\n        align-items: center;\r\n        gap: 12px;\r\n        font-family: Georgia, 'Times New Roman', Times, serif; \r\n        letter-spacing: -0.02em;\r\n    }\r\n\r\n    .mc-insight-box p {\r\n        margin-bottom: 0;\r\n        color: #334155;\r\n        font-size: 16px;\r\n        line-height: 1.6;\r\n        font-family: inherit; \r\n    }\r\n\r\n    \/* -----------------------------------------------------------\r\n        STANDARD LISTS (Brand Color Bullets)\r\n    ----------------------------------------------------------- *\/\r\n    .mc-list {\r\n        list-style: none;\r\n        padding-left: 0;\r\n        margin-bottom: 20px;\r\n    }\r\n\r\n    .mc-list li {\r\n        position: relative;\r\n        padding-left: 24px;\r\n        margin-bottom: 10px;\r\n    }\r\n\r\n    .mc-list li::before {\r\n        content: \"\u2022\";\r\n        color: #0288dc; \/* Brand Color *\/\r\n        font-weight: bold;\r\n        font-size: 1.5em;\r\n        position: absolute;\r\n        left: 0;\r\n        top: -2px; \/* Aligns bullet with the center of the first line *\/\r\n        line-height: 1;\r\n    }\r\n\r\n    \/* -----------------------------------------------------------\r\n        FAQ ACCORDION STYLES\r\n    ----------------------------------------------------------- *\/\r\n    .faq-item { margin-bottom: 15px; }\r\n\r\n    .faq-header {\r\n        background-color: #0288dc;\r\n        padding: 15px 25px;\r\n        border-radius: 8px;\r\n        cursor: pointer;\r\n        display: flex;\r\n        justify-content: space-between;\r\n        align-items: center;\r\n        transition: background-color 0.3s ease;\r\n    }\r\n\r\n    .faq-header:hover { background-color: #0277bd; }\r\n\r\n    .faq-header h3 {\r\n        color: #ffffff !important;\r\n        font-family: inherit;\r\n        font-size: 16px;\r\n        font-weight: 500;\r\n        margin: 0;\r\n        line-height: 1.4em;\r\n    }\r\n\r\n    .faq-icon {\r\n        width: 10px;\r\n        height: 10px;\r\n        border-right: 2px solid #ffffff;\r\n        border-bottom: 2px solid #ffffff;\r\n        transform: rotate(45deg);\r\n        transition: transform 0.3s ease;\r\n        margin-left: 15px;\r\n        flex-shrink: 0;\r\n    }\r\n\r\n    .faq-item.active .faq-icon {\r\n        transform: rotate(-135deg);\r\n        margin-top: 5px;\r\n    }\r\n\r\n    .faq-body {\r\n        max-height: 0;\r\n        overflow: hidden;\r\n        transition: max-height 0.3s ease-out, padding 0.3s ease;\r\n        padding: 0 20px;\r\n        background: #fff;\r\n    }\r\n\r\n    .faq-item.active .faq-body {\r\n        max-height: 1500px;\r\n        padding-top: 20px;\r\n        padding-bottom: 10px;\r\n        border-bottom: none;\r\n    }\r\n\r\n    .faq-body p {\r\n        margin: 0;\r\n        padding-bottom: 10px;\r\n    }\r\n<\/style>\r\n\r\n<div class=\"mc-content-wrapper\">\r\n\r\n    <h2 id=\"basics\">1. Basic SQL interview questions for freshers<\/h2>\r\n    <p>Most interviews begin with basic SQL interview questions, but this section is not \u201ceasy.\u201d It tests whether you truly understand how SQL databases work at a foundational level, including how SQL statements interact with a database management system and how data is structured within relational database systems. <\/p>\r\n    <p>Interviewers expect you to go beyond definitions and explain how SQL is used to manage data stored, perform data retrieval, and execute different SQL commands effectively.<\/p>\r\n    <p>At this stage, you should be able to connect concepts to real scenarios, such as how a SQL query is used to fetch data, apply conditions using the WHERE clause, and work across multiple tables without creating data redundancy. <\/p>\r\n    <p>A clear understanding of how data is organized across one or more columns, and how SQL helps maintain data integrity, makes your answers more practical and impactful.<\/p>\r\n    \r\n    <h3>What is SQL and where is it used?<\/h3>\r\n    <p>SQL, or Structured Query Language, is used to interact with a database management system to store, retrieve, and manipulate data stored in tables. It is the backbone of almost all relational database systems, including Microsoft SQL Server, Oracle SQL, and MySQL.<\/p>\r\n    <p>If your fundamentals are still forming, revisiting <a href=\"https:\/\/mycareernet.in\/blogs\/common-interview-questions-and-answers-every-fresher-should-know\/\" target=\"_blank\">common interview questions and answers<\/a> helps strengthen your base before moving to advanced SQL interview questions and answers.<\/p>\r\n    \r\n    <h3>What are SQL commands and their types?<\/h3>\r\n    <p>SQL commands are used to perform different operations within a database management system, from defining the table structure to managing and modifying data stored. Understanding these commands helps you explain how SQL handles data manipulation, access control, and transaction flow in real scenarios.<\/p>\r\n    <p>SQL is divided into multiple command types, and interviewers expect clarity here:<\/p>\r\n    <ul class=\"mc-list\">\r\n        <li><strong>DDL (Data Definition Language)<\/strong> \u2192 CREATE, ALTER, DROP<\/li>\r\n        <li><strong>DML (Data Manipulation Language)<\/strong> \u2192 INSERT, UPDATE, DELETE<\/li>\r\n        <li><strong>DCL (Data Control Language)<\/strong> \u2192 GRANT, REVOKE<\/li>\r\n        <li><strong>TCL (Transaction Control Language)<\/strong> \u2192 COMMIT, ROLLBACK<\/li>\r\n    <\/ul>\r\n    <p>These SQL commands define how you interact with data, control access, and manage transactions.<\/p>\r\n\r\n    <div class=\"mc-insight-box\">\r\n        <h4>\ud83d\udca1 Recruiter insight<\/h4>\r\n        <p>Strong candidates explain why DDL and DML are separate, not just list them.<\/p>\r\n    <\/div>\r\n\r\n    <h3>What is a primary key and foreign key?<\/h3>\r\n    <p>A primary key uniquely identifies each row in a table and ensures data integrity, meaning no duplicate or null values are allowed in that column. A foreign key connects a child table to a parent table, maintaining relationships across multiple tables and ensuring consistent data flow within a database management system.<\/p>\r\n    <p><strong>Example:<\/strong><\/p>\r\n    <ul class=\"mc-list\">\r\n        <li><code>users<\/code> \u2192 primary key: <code>user_id<\/code><\/li>\r\n        <li><code>orders<\/code> \u2192 foreign key: <code>user_id<\/code><\/li>\r\n    <\/ul>\r\n    <p>This relationship allows you to retrieve matching values across tables, prevents data redundancy, and maintains a clean and reliable data structure when working with related datasets.<\/p>\r\n\r\n    <h3>What are NULL values and why do they matter?<\/h3>\r\n    <p>NULL values represent missing or undefined data. They behave differently from zero or empty strings and must be handled explicitly when writing a SQL query.<\/p>\r\n    <p>Handling null values correctly is critical in SQL query interview questions, especially when using:<\/p>\r\n    <ul class=\"mc-list\">\r\n        <li><code>IS NULL<\/code><\/li>\r\n        <li><code>IS NOT NULL<\/code><\/li>\r\n        <li><code>COALESCE()<\/code><\/li>\r\n    <\/ul>\r\n    <p>If a column contains null values and you apply conditions without handling them, your query may skip important rows or return incorrect results. Ignoring null values can break your query logic and impact data accuracy.<\/p>\r\n\r\n    <h3>What are aggregate functions?<\/h3>\r\n    <p>Aggregate functions help summarize data across one or more columns, making them essential for reporting and analysis. They are commonly used in data retrieval to calculate totals, averages, and counts from large datasets.<\/p>\r\n    <ul class=\"mc-list\">\r\n        <li><strong>COUNT()<\/strong> \u2192 counts rows<\/li>\r\n        <li><strong>SUM()<\/strong> \u2192 calculates total values<\/li>\r\n        <li><strong>AVG()<\/strong> \u2192 finds averages<\/li>\r\n        <li><strong>MAX() \/ MIN()<\/strong> \u2192 identify highest and lowest values<\/li>\r\n    <\/ul>\r\n    <p>You might use aggregate functions to calculate total sales from a sales table or count users in a users table, especially when working with aggregated data in analytics scenarios.<\/p>\r\n\r\n\r\n    <h2 id=\"core-concepts\">2. Core SQL concepts every fresher must know<\/h2>\r\n    <p>This is where SQL interview questions for developers and analyst roles start to differentiate candidates. At this stage, interviewers expect you to move beyond basic definitions and demonstrate how SQL works internally within a database management system. <\/p>\r\n    <p>It is not just about writing a SQL query, but understanding how that query is executed, how data is processed, and how different components work together to ensure data integrity and performance.<\/p>\r\n    <p>You are also expected to show awareness of how SQL operates within relational database systems, how data is accessed across multiple tables, and how efficient query design helps improve query performance. <\/p>\r\n    \r\n    <h3>What is a database engine?<\/h3>\r\n    <p>A database engine is the core component that processes SQL statements, manages storage, and executes query plans.<\/p>\r\n    <p>For example, in SQL server, the engine decides:<\/p>\r\n    <ul class=\"mc-list\">\r\n        <li>How to scan tables<\/li>\r\n        <li>Whether to use indexes<\/li>\r\n        <li>How to optimize execution<\/li>\r\n    <\/ul>\r\n    <p>Understanding this helps you improve query performance instead of guessing.<\/p>\r\n\r\n    <h3>What are Indexes and how do they impact performance?<\/h3>\r\n    <p>Indexes are used to speed up data retrieval. Without indexes, the database scans entire tables.<\/p>\r\n    <p><strong>Types:<\/strong><\/p>\r\n    <ul class=\"mc-list\">\r\n        <li><strong>Clustered index<\/strong> \u2192 defines physical storage order<\/li>\r\n        <li><strong>Non-clustered index<\/strong> \u2192 separate lookup structure<\/li>\r\n    <\/ul>\r\n    <p>Indexes are crucial for frequently queried columns and large datasets.<\/p>\r\n\r\n    <div class=\"mc-insight-box\">\r\n        <h4>\ud83d\udca1 Pro tip<\/h4>\r\n        <p>Mentioning execution plans and query optimization shows advanced thinking even as a fresher.<\/p>\r\n    <\/div>\r\n\r\n    <h3>What are ACID properties?<\/h3>\r\n    <p>ACID properties define how transactions are handled within a database management system to ensure reliability and consistency of data stored. They are especially important in systems that handle frequent updates, such as online transaction processing, where maintaining accurate and consistent data is critical.<\/p>\r\n    <p>ACID ensures reliable transactions:<\/p>\r\n    <ul class=\"mc-list\">\r\n        <li><strong>Atomicity<\/strong><\/li>\r\n        <li><strong>Consistency<\/strong><\/li>\r\n        <li><strong>Isolation<\/strong><\/li>\r\n        <li><strong>Durability<\/strong><\/li>\r\n    <\/ul>\r\n\r\n    <h3>What are JOINs and why are they important?<\/h3>\r\n    <p>JOINs are used to combine data from two tables or more based on a related column, allowing you to retrieve meaningful information from multiple tables in a single SQL query. They are essential when working with relational data, especially where relationships are defined using a foreign key.<\/p>\r\n    <ul class=\"mc-list\">\r\n        <li><strong>INNER JOIN<\/strong> \u2192 returns only matching rows<\/li>\r\n        <li><strong>LEFT JOIN<\/strong> \u2192 returns all rows from the left table, along with matching rows<\/li>\r\n        <li><strong>RIGHT JOIN<\/strong> \u2192 returns all rows from the right table<\/li>\r\n        <li><strong>FULL JOIN<\/strong> \u2192 returns all rows from both tables<\/li>\r\n    <\/ul>\r\n    <p>JOINs are central to almost all SQL coding interview questions, as they test your ability to connect datasets, handle relationships, and write efficient queries.<\/p>\r\n\r\n\r\n    <h2 id=\"queries\">3. SQL query-based interview questions<\/h2>\r\n    <p>Interviewers use these SQL query interview questions to evaluate how well you apply logic, work with multiple tables, and structure queries across multiple columns. Your ability to write correct and efficient queries, while maintaining clear query logic, is what differentiates strong candidates.<\/p>\r\n    \r\n    <h3>Query to find duplicate records<\/h3>\r\n    <div class=\"mc-code-wrapper\">\r\n        <button class=\"mc-copy-btn\" title=\"Copy code\" aria-label=\"Copy code\">\r\n            <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><rect x=\"9\" y=\"9\" width=\"13\" height=\"13\" rx=\"2\" ry=\"2\"><\/rect><path d=\"M5 15H4a2 2 0 0 1-2-2V4a2 2 0 0 1 2-2h9a2 2 0 0 1 2 2v1\"><\/path><\/svg>\r\n        <\/button>\r\n        <pre><code>SELECT column_name, COUNT(*)\r\nFROM table_name\r\nGROUP BY column_name\r\nHAVING COUNT(*) > 1;<\/code><\/pre>\r\n    <\/div>\r\n    <p>Used to identify duplicate rows or duplicate records.<\/p>\r\n\r\n    <h3>Query to find second highest salary<\/h3>\r\n    <div class=\"mc-code-wrapper\">\r\n        <button class=\"mc-copy-btn\" title=\"Copy code\" aria-label=\"Copy code\">\r\n            <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><rect x=\"9\" y=\"9\" width=\"13\" height=\"13\" rx=\"2\" ry=\"2\"><\/rect><path d=\"M5 15H4a2 2 0 0 1-2-2V4a2 2 0 0 1 2-2h9a2 2 0 0 1 2 2v1\"><\/path><\/svg>\r\n        <\/button>\r\n        <pre><code>SELECT MAX(salary)\r\nFROM employees\r\nWHERE salary < (SELECT MAX(salary) FROM employees);<\/code><\/pre>\r\n    <\/div>\r\n    <p>This uses an outer query with a subquery.<\/p>\r\n\r\n    <h3>What is a correlated subquery?<\/h3>\r\n    <p>A correlated subquery runs once for each row in the outer query.<\/p>\r\n    <div class=\"mc-code-wrapper\">\r\n        <button class=\"mc-copy-btn\" title=\"Copy code\" aria-label=\"Copy code\">\r\n            <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><rect x=\"9\" y=\"9\" width=\"13\" height=\"13\" rx=\"2\" ry=\"2\"><\/rect><path d=\"M5 15H4a2 2 0 0 1-2-2V4a2 2 0 0 1 2-2h9a2 2 0 0 1 2 2v1\"><\/path><\/svg>\r\n        <\/button>\r\n        <pre><code>SELECT name\r\nFROM employees e1\r\nWHERE salary > (\r\n   SELECT AVG(salary)\r\n   FROM employees e2\r\n   WHERE e1.department = e2.department\r\n);<\/code><\/pre>\r\n    <\/div>\r\n    <p>This is a common pattern in intermediate SQL interview questions.<\/p>\r\n\r\n    <h3>What is a Common Table Expression (CTE)?<\/h3>\r\n    <p>A common table expression simplifies complex queries:<\/p>\r\n    <div class=\"mc-code-wrapper\">\r\n        <button class=\"mc-copy-btn\" title=\"Copy code\" aria-label=\"Copy code\">\r\n            <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><rect x=\"9\" y=\"9\" width=\"13\" height=\"13\" rx=\"2\" ry=\"2\"><\/rect><path d=\"M5 15H4a2 2 0 0 1-2-2V4a2 2 0 0 1 2-2h9a2 2 0 0 1 2 2v1\"><\/path><\/svg>\r\n        <\/button>\r\n        <pre><code>WITH SalesCTE AS (\r\n   SELECT *\r\n   FROM sales\r\n)\r\nSELECT *\r\nFROM SalesCTE;<\/code><\/pre>\r\n    <\/div>\r\n    <p>It improves readability and helps manage complex logic.<\/p>\r\n\r\n    <h3>What are window functions?<\/h3>\r\n    <p>Window functions perform calculations across rows without collapsing them.<\/p>\r\n    <p><strong>Examples:<\/strong><\/p>\r\n    <ul class=\"mc-list\">\r\n        <li><code>ROW_NUMBER()<\/code><\/li>\r\n        <li><code>RANK()<\/code><\/li>\r\n        <li><code>DENSE_RANK()<\/code><\/li>\r\n    <\/ul>\r\n    <p>These are heavily used in analytics and appear in advanced SQL interview questions.<\/p>\r\n\r\n    <div class=\"mc-insight-box\">\r\n        <h4>\ud83d\udca1 Recruiter insight<\/h4>\r\n        <p>Candidates who confidently explain window functions often move ahead quickly.<\/p>\r\n    <\/div>\r\n\r\n\r\n    <h2 id=\"data-analyst\">4. SQL interview questions for data analyst and entry-level roles<\/h2>\r\n    <p>SQL interview questions for <a href=\"https:\/\/mycareernet.in\/blogs\/what-does-a-data-analyst-do-complete-career-guide-for-freshers\/\" target=\"_blank\">data analyst and entry-level roles<\/a> often go beyond basic syntax. The focus shifts to how effectively you can use SQL in real-world scenarios, working with datasets, solving business problems, and writing queries that deliver meaningful insights.<\/p>\r\n    <p>You may be asked to clean and transform data, work with joins across multiple tables, or optimize queries for better performance. Interviewers also look at how you approach a problem, how clearly you think, structure your queries, and validate your results.<\/p>\r\n    \r\n    <h3>How do you filter data?<\/h3>\r\n    <p>Filtering helps you narrow down large datasets to only the records that meet specific conditions. It is essential for focusing analysis on relevant data and avoiding unnecessary noise.<\/p>\r\n    <div class=\"mc-code-wrapper\">\r\n        <button class=\"mc-copy-btn\" title=\"Copy code\" aria-label=\"Copy code\">\r\n            <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><rect x=\"9\" y=\"9\" width=\"13\" height=\"13\" rx=\"2\" ry=\"2\"><\/rect><path d=\"M5 15H4a2 2 0 0 1-2-2V4a2 2 0 0 1 2-2h9a2 2 0 0 1 2 2v1\"><\/path><\/svg>\r\n        <\/button>\r\n        <pre><code>SELECT *\r\nFROM sales\r\nWHERE revenue > 1000;<\/code><\/pre>\r\n    <\/div>\r\n    <p>The WHERE clause ensures you return only the rows needed.<\/p>\r\n\r\n    <h3>How do you join two tables?<\/h3>\r\n    <p>Joining allows you to combine data from multiple tables based on a common key. This is useful when related information is stored separately but needs to be analyzed together.<\/p>\r\n    <div class=\"mc-code-wrapper\">\r\n        <button class=\"mc-copy-btn\" title=\"Copy code\" aria-label=\"Copy code\">\r\n            <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><rect x=\"9\" y=\"9\" width=\"13\" height=\"13\" rx=\"2\" ry=\"2\"><\/rect><path d=\"M5 15H4a2 2 0 0 1-2-2V4a2 2 0 0 1 2-2h9a2 2 0 0 1 2 2v1\"><\/path><\/svg>\r\n        <\/button>\r\n        <pre><code>SELECT o.order_id, u.name\r\nFROM orders o\r\nJOIN users u\r\nON o.user_id = u.user_id;<\/code><\/pre>\r\n    <\/div>\r\n    <p>This connects two tables using a foreign key.<\/p>\r\n\r\n    <h3>How do you analyze sales data?<\/h3>\r\n    <div class=\"mc-code-wrapper\">\r\n        <button class=\"mc-copy-btn\" title=\"Copy code\" aria-label=\"Copy code\">\r\n            <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><rect x=\"9\" y=\"9\" width=\"13\" height=\"13\" rx=\"2\" ry=\"2\"><\/rect><path d=\"M5 15H4a2 2 0 0 1-2-2V4a2 2 0 0 1 2-2h9a2 2 0 0 1 2 2v1\"><\/path><\/svg>\r\n        <\/button>\r\n        <pre><code>SELECT region, SUM(revenue) AS total_revenue\r\nFROM sales\r\nGROUP BY region;<\/code><\/pre>\r\n    <\/div>\r\n    <p>This uses aggregate functions to analyze aggregated data.<\/p>\r\n\r\n    <h3>How do you handle NULL values in analysis?<\/h3>\r\n    <ul class=\"mc-list\">\r\n        <li>Use <code>COALESCE()<\/code><\/li>\r\n        <li>Filter using <code>IS NULL<\/code><\/li>\r\n        <li>Replace missing values carefully<\/li>\r\n    <\/ul>\r\n    <p>Handling null values correctly ensures accurate results.<\/p>\r\n\r\n\r\n    <h2 id=\"data-science\">5. SQL interview questions for data science roles<\/h2>\r\n    <p>For data science roles, SQL shifts from simple data retrieval to preparing, cleaning, and structuring data for analysis and modeling. Interviewers expect you to demonstrate how you work with raw data, transform it into usable formats, and ensure accuracy before it is used in analytical workflows.<\/p>\r\n    <p>This is where your understanding of query performance, data quality, and efficient query design becomes especially important.<\/p>\r\n\r\n    <h3>How do you prepare data for analysis?<\/h3>\r\n    <p>Preparing data is a critical step in data science, as models are only as good as the data they are built on. SQL is commonly used to clean and organize datasets before analysis.<\/p>\r\n    <ul class=\"mc-list\">\r\n        <li>Remove duplicate rows<\/li>\r\n        <li>Handle null values<\/li>\r\n        <li>Eliminate redundant data<\/li>\r\n        <li>Normalize data structure<\/li>\r\n    <\/ul>\r\n    <p>This ensures clean, consistent input for models and improves overall reliability of results.<\/p>\r\n\r\n    <h3>How do you optimize queries?<\/h3>\r\n    <p>In data science roles, you often work with large datasets, so optimizing queries is essential to ensure faster processing and better performance.<\/p>\r\n    <ul class=\"mc-list\">\r\n        <li>Use indexes<\/li>\r\n        <li>Analyze execution plans<\/li>\r\n        <li>Reduce unnecessary joins<\/li>\r\n        <li>Limit scanned data<\/li>\r\n    <\/ul>\r\n\r\n    <h3>What are stored procedures?<\/h3>\r\n    <p>Stored procedures are precompiled SQL code stored in the database, used to execute repeated operations efficiently. They are especially relevant in systems like SQL server, where performance and reusability are key.<\/p>\r\n    <p><strong>Benefits:<\/strong><\/p>\r\n    <ul class=\"mc-list\">\r\n        <li>Reusability<\/li>\r\n        <li>Faster execution<\/li>\r\n        <li>Security<\/li>\r\n    <\/ul>\r\n\r\n    <h3>OLTP vs OLAP<\/h3>\r\n    <p>Understanding the difference between transactional and analytical systems is important in data-focused roles.<\/p>\r\n    <ul class=\"mc-list\">\r\n        <li><strong>Online transaction processing (OLTP)<\/strong> \u2192 supports real-time operations and frequent updates<\/li>\r\n        <li><strong>Online analytical processing (OLAP)<\/strong> \u2192 supports analysis, reporting, and insights from large datasets<\/li>\r\n    <\/ul>\r\n    <p>This distinction helps explain how SQL is used differently depending on the use case.<\/p>\r\n\r\n\r\n    <h2 id=\"mistakes\">6. Common SQL interview mistakes<\/h2>\r\n    <p>Even strong candidates lose marks due to simple, avoidable mistakes. These mistakes are rarely about not knowing SQL, but about how concepts are applied under pressure. Interviewers are evaluating not just correctness, but how efficiently and clearly you approach a problem.<\/p>\r\n    \r\n    <h3>Writing inefficient queries<\/h3>\r\n    <p>Ignoring query performance and indexes can significantly slow down execution, especially when working with large datasets. Many candidates write queries that return the correct result but rely on full table scans instead of optimized access paths. Understanding how indexes and filters work together helps you write more efficient queries.<\/p>\r\n    \r\n    <h3>Not handling NULL values<\/h3>\r\n    <p>Incorrect handling of null values often leads to inaccurate results or missing data. Since null behaves differently from zero or empty strings, failing to handle it properly can break your query logic. Using conditions like <code>IS NULL<\/code> or functions like <code>COALESCE()<\/code> ensures your results remain reliable.<\/p>\r\n    \r\n    <h3>Weak understanding of relationships<\/h3>\r\n    <p>Not using primary key and foreign key correctly leads to incorrect joins and inconsistent data. When working across multiple tables, a clear understanding of how relationships are defined is essential to retrieve accurate and meaningful results.<\/p>\r\n    \r\n    <h3>Overusing joins<\/h3>\r\n    <p>Unnecessary joins across multiple tables can make queries complex, harder to read, and slower to execute. It is important to understand when a join is required and when simpler query structures can achieve the same result more efficiently.<\/p>\r\n    \r\n    <h3>Poor explanation<\/h3>\r\n    <p>Even correct answers fail without clarity. If you cannot explain your SQL query, the reasoning behind it, or how it can be improved, it reduces your overall impact. Interviewers value candidates who can clearly communicate their approach and thought process.<\/p>\r\n\r\n\r\n    <h2 id=\"prep-tips\">7. How to prepare for SQL interviews as a fresher<\/h2>\r\n    <p>Preparation for SQL interview questions for freshers should go beyond memorizing concepts. The goal is to build confidence in applying SQL to real problems, understanding how queries behave, and improving performance when working with actual datasets.<\/p>\r\n    \r\n    <h3>Practice real SQL problems<\/h3>\r\n    <p>Start by working on structured SQL practice questions that cover a range of difficulty levels. Instead of solving isolated problems, try to complete full queries from start to finish, including writing, testing, and validating results. This helps you build a stronger understanding of how queries work in real scenarios.<\/p>\r\n    <p>Utilizing a <a href=\"https:\/\/mycareernet.co\/blogs\/what-is-a-mock-assessment-why-every-job-seeker-should-try-one\/\" target=\"_blank\">mock assessment<\/a> is especially useful because it simulates real SQL coding interview questions, helping you get comfortable with time constraints and question patterns commonly seen in interviews.<\/p>\r\n    \r\n    <h3>Focus on writing queries daily<\/h3>\r\n    <p>Consistency is key when preparing for SQL interviews. You should be able to confidently:<\/p>\r\n    <ul class=\"mc-list\">\r\n        <li>Write a query<\/li>\r\n        <li>Debug errors<\/li>\r\n        <li>Optimize performance<\/li>\r\n    <\/ul>\r\n    <p>Daily practice improves your ability to structure queries, handle edge cases, and refine your query logic.<\/p>\r\n\r\n    <h3>Learn performance basics<\/h3>\r\n    <p>Understanding performance is what separates average candidates from strong ones. You should be familiar with how queries are executed and how they can be improved.<\/p>\r\n    <ul class=\"mc-list\">\r\n        <li>Execution plans<\/li>\r\n        <li>Query plans<\/li>\r\n        <li>Indexing<\/li>\r\n    <\/ul>\r\n    <p>These concepts help you analyze how the database processes your queries and allow you to improve query performance.<\/p>\r\n\r\n    <h3>Build small projects<\/h3>\r\n    <p>Working on small projects helps you apply SQL concepts in a practical way. Use sample datasets such as a users table or a sales table to practice real-world scenarios. For example, you can analyze sales trends, filter user data based on conditions, or join data across multiple tables.<\/p>\r\n\r\n    <h3>Explore job expectations<\/h3>\r\n    <p>Understanding what employers expect helps you prepare more effectively. Instead of focusing only on theory, look at real job requirements to see which skills are in demand. Check out <a href=\"https:\/\/mycareernet.in\/blogs\/how-to-write-a-resume-for-freshers-step-by-step-writing-guide\/\" target=\"_blank\">how to write your resume<\/a> and explore entry-level roles to understand the tools, responsibilities, and expectations associated with your desired position.<\/p>\r\n\r\n    <hr style=\"border: none; border-top: 1px solid #eef2f6; margin: 40px 0;\">\r\n\r\n    <h3>Take the next step with MyCareernet<\/h3>\r\n    <p>Learning SQL concepts is important, but real confidence comes from applying them in practical scenarios. From writing queries to handling SQL interview questions, improving query performance, and working with real datasets, consistent practice is what prepares you for actual interviews.<\/p>\r\n    <p>MyCareernet helps you bridge that gap. It connects your preparation with real opportunities by giving you access to curated roles, hiring companies, and insights into what employers expect in entry-level SQL and data roles. This makes your preparation more focused, relevant, and aligned with real job requirements.<\/p>\r\n    <p>If you are preparing for database interview questions, <a href=\"https:\/\/mycareernet.in\/blogs\/data-analyst-interview-questions-and-answers-for-freshers\/\" target=\"_blank\">data analyst interview questions<\/a>, or roles in development and analytics, <a href=\"https:\/\/mycareernet.co\/mycareernet\/jobs\" target=\"_blank\">apply for jobs on MyCareernet<\/a> to connect your skills with opportunities that match your career goals.<\/p>\r\n\r\n\r\n    <h2 id=\"faq\">8. Frequently asked questions<\/h2>\r\n    <div class=\"faq-accordion-wrapper\">\r\n        \r\n        <div class=\"faq-item\">\r\n            <div class=\"faq-header\">\r\n                <h3>What are the most important SQL interview questions for freshers?<\/h3>\r\n                <div class=\"faq-icon\"><\/div>\r\n            <\/div>\r\n            <div class=\"faq-body\">\r\n                <p>The most common SQL interview questions for freshers focus on JOINs, aggregate functions, subqueries, indexes, and window functions. These topics appear frequently in SQL interview questions and answers because they reflect real-world usage.<\/p>\r\n            <\/div>\r\n        <\/div>\r\n        \r\n        <div class=\"faq-item\">\r\n            <div class=\"faq-header\">\r\n                <h3>How can I improve my SQL query skills?<\/h3>\r\n                <div class=\"faq-icon\"><\/div>\r\n            <\/div>\r\n            <div class=\"faq-body\">\r\n                <p>Practice consistently using SQL practice questions and focus on how to write a query from scratch. Over time, this improves your handling of null values, query logic, and performance. You can also explore <a href=\"https:\/\/mycareernet.co\/blogs\/improve-your-job-readiness-with-coding-software-and-it-mock-assessments\/\" target=\"_blank\">mock assessments for coding<\/a> to test your skills.<\/p>\r\n            <\/div>\r\n        <\/div>\r\n        \r\n        <div class=\"faq-item\">\r\n            <div class=\"faq-header\">\r\n                <h3>Are SQL Server interview questions different from general SQL questions?<\/h3>\r\n                <div class=\"faq-icon\"><\/div>\r\n            <\/div>\r\n            <div class=\"faq-body\">\r\n                <p>Core concepts remain the same, but SQL server interview questions often include stored procedures, indexing, and query performance tuning. Understanding how the database engine works gives you an advantage.<\/p>\r\n            <\/div>\r\n        <\/div>\r\n        \r\n        <div class=\"faq-item\">\r\n            <div class=\"faq-header\">\r\n                <h3>How important is query performance in SQL interviews?<\/h3>\r\n                <div class=\"faq-icon\"><\/div>\r\n            <\/div>\r\n            <div class=\"faq-body\">\r\n                <p>Query performance is critical because recruiters expect efficient data handling, not just correct output. Knowing how to use indexes and analyze execution plans helps you improve query performance.<\/p>\r\n            <\/div>\r\n        <\/div>\r\n        \r\n        <div class=\"faq-item\">\r\n            <div class=\"faq-header\">\r\n                <h3>Do freshers need to learn advanced SQL topics?<\/h3>\r\n                <div class=\"faq-icon\"><\/div>\r\n            <\/div>\r\n            <div class=\"faq-body\">\r\n                <p>Yes, concepts like window functions, common table expressions (CTEs), and correlated subqueries are common in interviews. These are especially important for analytics and <a href=\"https:\/\/mycareernet.co\/blogs\/how-to-become-a-data-analyst-in-complete-beginner-roadmap\/\" target=\"_blank\">data science roles<\/a>.<\/p>\r\n            <\/div>\r\n        <\/div>\r\n\r\n    <\/div>\r\n<\/div>\r\n\r\n<script>\r\n    document.addEventListener(\"DOMContentLoaded\", function() {\r\n        const copyIcon = `<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><rect x=\"9\" y=\"9\" width=\"13\" height=\"13\" rx=\"2\" ry=\"2\"><\/rect><path d=\"M5 15H4a2 2 0 0 1-2-2V4a2 2 0 0 1 2-2h9a2 2 0 0 1 2 2v1\"><\/path><\/svg>`;\r\n        const checkIcon = `<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"#10b981\" stroke-width=\"3\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><polyline points=\"20 6 9 17 4 12\"><\/polyline><\/svg>`;\r\n        \r\n        \/\/ Copy to clipboard functionality\r\n        const copyBtns = document.querySelectorAll('.mc-copy-btn');\r\n        copyBtns.forEach(btn => {\r\n            btn.addEventListener('click', () => {\r\n                const codeBlock = btn.nextElementSibling.querySelector('code') || btn.nextElementSibling;\r\n                \r\n                navigator.clipboard.writeText(codeBlock.innerText).then(() => {\r\n                    \/\/ Change to checkmark icon\r\n                    btn.innerHTML = checkIcon;\r\n                    \r\n                    \/\/ Revert back to copy icon after 2 seconds\r\n                    setTimeout(() => { \r\n                        btn.innerHTML = copyIcon; \r\n                    }, 2000);\r\n                }).catch(err => {\r\n                    console.error('Failed to copy code: ', err);\r\n                });\r\n            });\r\n        });\r\n\r\n        \/\/ FAQ Accordion functionality\r\n        const headers = document.querySelectorAll('.faq-header');\r\n        headers.forEach(header => {\r\n            header.addEventListener('click', () => {\r\n                header.parentElement.classList.toggle('active');\r\n            });\r\n        });\r\n    });\r\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1c6f753a e-flex e-con-boxed e-con e-parent\" data-id=\"1c6f753a\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-78bc89c0 e-con-full e-flex e-con e-child\" data-id=\"78bc89c0\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-7bfa5609 e-con-full author-box e-flex e-con e-child\" data-id=\"7bfa5609\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t<div class=\"elementor-element elementor-element-60cd623f e-con-full e-flex e-con e-child\" data-id=\"60cd623f\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-41abafe elementor-widget elementor-widget-image\" data-id=\"41abafe\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;ekit_we_effect_on&quot;:&quot;none&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"500\" height=\"500\" src=\"https:\/\/mycareernet.co\/blogs\/wp-content\/uploads\/2025\/09\/MyCareernet_Logo.jpg\" class=\"attachment-full size-full wp-image-25691\" alt=\"MyCareernet\" srcset=\"https:\/\/mycareernet.co\/blogs\/wp-content\/uploads\/2025\/09\/MyCareernet_Logo.jpg 500w, https:\/\/mycareernet.co\/blogs\/wp-content\/uploads\/2025\/09\/MyCareernet_Logo-300x300.jpg 300w, https:\/\/mycareernet.co\/blogs\/wp-content\/uploads\/2025\/09\/MyCareernet_Logo-150x150.jpg 150w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-294bf715 e-con-full e-flex e-con e-child\" data-id=\"294bf715\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5fce1e6 elementor-widget elementor-widget-heading\" data-id=\"5fce1e6\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;ekit_we_effect_on&quot;:&quot;none&quot;}\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">MyCareernet<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f197104 elementor-widget elementor-widget-heading\" data-id=\"f197104\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;ekit_we_effect_on&quot;:&quot;none&quot;}\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Author<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-389aa8ec elementor-widget elementor-widget-text-editor\" data-id=\"389aa8ec\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;ekit_we_effect_on&quot;:&quot;none&quot;}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>MyCareernet brings expert insights and tips to help job seekers crack interviews and grow their careers.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>The concept of a multi-brand system has gained traction, allowing businesses to manage various brands.<\/p>\n","protected":false},"author":3,"featured_media":28279,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30],"tags":[],"class_list":["post-28269","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-interview-preparation"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/mycareernet.co\/blogs\/wp-json\/wp\/v2\/posts\/28269","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mycareernet.co\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mycareernet.co\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mycareernet.co\/blogs\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/mycareernet.co\/blogs\/wp-json\/wp\/v2\/comments?post=28269"}],"version-history":[{"count":10,"href":"https:\/\/mycareernet.co\/blogs\/wp-json\/wp\/v2\/posts\/28269\/revisions"}],"predecessor-version":[{"id":28283,"href":"https:\/\/mycareernet.co\/blogs\/wp-json\/wp\/v2\/posts\/28269\/revisions\/28283"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mycareernet.co\/blogs\/wp-json\/wp\/v2\/media\/28279"}],"wp:attachment":[{"href":"https:\/\/mycareernet.co\/blogs\/wp-json\/wp\/v2\/media?parent=28269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mycareernet.co\/blogs\/wp-json\/wp\/v2\/categories?post=28269"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mycareernet.co\/blogs\/wp-json\/wp\/v2\/tags?post=28269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}