473,320 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

progressive number

Consider two tables:

book(id, title, date_written , author_id)
author(id, name)

the date_written field is a DATE field ad rappresents the date the book
was written.

i would like to make a query like this:

SELECT name , title , date_written
FROM book INNER JOIN author ON ( book.author_id = author.id )
ORDER BY author.id , time_written

the result would be

King , Running Man , 1978-9-12
King , Salem's Lot , 1980-3-29
[...]
Shakespeare, Romeo and Juliet , 1214-6-13
Shakespeare , Amlet , 1216-11-6
Shakespeare , ... , 1226-5-22
[...]

but I would like to add a column with the "sequence number" of the book,
related to the author, like

King , Running Man , 1 , 1978-9-12
King , Salem's Lot , 2 , 1980-3-29
[...]
Shakespeare, 1 , Romeo and Juliet , 1214-6-13
Shakespeare , 2 , Amlet , 1216-11-6
Shakespeare , 3 , ... , 1226-5-22
[...]

what query must I issue?
can anyone help me?

tia

--
Mattia Cazzola

Jul 19 '05 #1
0 2159

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Dianne Combs | last post by:
Dear Online Reader or Editor ... If you could ... please take a look at our new online treeless edition newspapers, The Northeast Progressive Advocate-Journal and our sister newspaper the San...
8
by: EAS | last post by:
Hey, I'm new to python (and programming in general) so I'll prolly be around here a lot... Anyways, I've found out how to make a "guess my number game" where the player guesses a number between...
5
by: Pecos Bill | last post by:
Hi to everybody, I'd like to know how to extract a progressive number in a select. Example.. Select * from employers Name Surname Position Age Hire Date Progressive...
3
by: Girish | last post by:
Hi All, I have written a component(ATL COM) that wraps Xerces C++ parser. I am firing necessary events for each of the notifications that I have handled for the Content and Error handler. The...
1
by: Chris Jakeman | last post by:
Hi, Internet Explorer doesn't load JPGs progressively. I need to show a large graphic (100KB) on dial-up lines, so I searched for a way to emulate progressive loading of images. Couldn't find...
0
by: Ryan Cooper | last post by:
Hello .NET Gurus! I have been posting messages all over the .NET forums to no avail, so I thought I'd give this newsgroup a shot as well. I am trying to figure out how to detect if a...
1
by: Carlo | last post by:
I have a table with a lot of fields. One is a numeric field. How can I introduce in these field a progressive number. I have to change at times the start number. example:...
0
by: nhacnhac | last post by:
Hi Guys does anyone knows if the a JPEG file saved as JFIF version 1.02 is always considered progressive? I need to create a program in C# to open JPEG files and upload just the non-progressive...
3
by: mukesh | last post by:
I have designed a form in ms access to show the account of firms. In the total column i need a progressive total of one or more column of this form. what to do please thanks in advance
5
by: byteit101 | last post by:
I am working a an Image processing program, and I want to save my jpegs as being progressive (blurry to sharp instead of line by line while it loads). this does not work howerver: ImageCodecInfo...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.