Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Exclamation Unanswered: Urgent HELP required

    Dear Friend,
    I'm in a problem during my work. I have to generate serial no.s for each record retrived by a SQL statment with some filter expression specified by a WHERE clause. Can u tell me how can I do it.
    Let the query is of the form:

    SELECT emp_name, dept_code from emp_tab where dept_code='D1'

    please modify the sql such that the output looks like:

    sr_no emp_name dept_code
    1 John D1
    2 Rebeca D1
    3 Evan D1

    If u can solve the problem it will be better if u plz send be the soln. in my mail account

    - Bitan Kr. Kundu.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    The simplest answer (by far) is to let the client synthesize the numbers itself. This is ugly in most database engines, and it is provided as a built in feature of many server access libraries.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts