Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Identity column in query result

slaha11slaha11 Member Posts: 28

I am firing a query like:

SELECT TaskName, StartDate FROMTasks
WHERE StartDate >= '01-Aug-2003'

Now the result comes as:

TaskName StartDate
--------------------------
Task1 01-Aug-2003
Task5 10-Oct-2003

etc.

Now what I want is this:


Sl. No. TaskName StartDate
----------------------------------
1 Task1 01-Aug-2003
2 Task5 10-Oct-2003


How do I get the Sl. No. field (it does not exist in the table).
Can I do it?

-surajit






Comments

Sign In or Register to comment.