EDENIAS

EDEN IAS is a premier coaching institute dedicated to preparing aspirants for the UPSC Civil Services Examination (CSE). Established in 2018, with the vision of nurturing future leaders and civil servants, EDEN IAS offers comprehensive and result-oriented coaching programs designed to equip candidates with the knowledge, skills, and confidence required to excel in one of the most competitive exams in the country. EDEN IAS is known for its ecosystem of learning that is student-oriented, demand-driven and guided by modern technology like AI.

Interests: education
Skills: upsc

Website: https://edenias.com/

All authors

It seems we can’t find what you’re looking for. Perhaps searching can help.

Read the latest Blogs

Visit the forum

Question of the Day

Fun with JSON I

I have some data in a table:

CREATE TABLE #test_data
(
    id INT PRIMARY KEY,
    name VARCHAR(100),
    birth_date DATE
);

-- Step 2: Insert rows  
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');

If I run this query, how many rows are returned?

SELECT *
FROM OPENJSON(
     (
         SELECT t.* FROM #test_data AS t FOR JSON PATH
     )
             ) t;

See possible answers

EDENIAS

Blogs

AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning

AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention

Flyway Tips: Multiple Projects

Forums

Can an Azure App Service Managed Identity be used for SQL Login?

Azure Synapse database refresh

how to write this query?

Question of the Day

Fun with JSON I