DEV Community

Judy
Judy

Posted on

Top/Bottom N: getting values #eg73

Find scores of students who rank in top 2 based on the following Scores table.

Image description
SPL script:

Image description
A1 Connect to the database;
A2 Query students’ scores;
A3 Get scores of students who rank in top 2. Note: The comma means returning the two values ranking in top 2.

Execution result:

Image description

Open source SPL source address

Download

Top comments (0)

Read next

shaiksalam9182 profile image

Building an Event-Driven Architecture for Content Embedding Generation with AWS Bedrock, DynamoDb, and AWS Batch

Salam Shaik -

kajalshinde profile image

What to Expect from Clinical Research Courses with Assured Placements

kajal shinde -

roboword profile image

Demystifying the Man-Month (Part 2)

Taka Saito -

thiagomg profile image

Using flutter with native resources on apple silicon processors

Thiago Massari Guedes -