question

Sandeep654321 avatar image
Sandeep654321 asked

I have a list of customers. For each customer there are n contracts,I need to display the customer with latest contract.Cna you write me a query?

I have a list of customers with n number of contracts for each customer and I want to display the customers with latest contract.write me a query using nested loop.without using while,If,for loops?

sqlquery
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green avatar image anthony.green commented ·
We won't do your work for you.

If you are stuck on something, please post sample code to recreate the data, what you have tried so far, what you're stuck on and what is the expected outcomes are, to get better answers to your actual issue.

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.