Results 1 to 2 of 2

Thread: I want to know the balance for a particular date

  1. #1

    I want to know the balance for a particular date

    Query: 1) name balance bal_date
    shrapova 10000 20-may-07
    shrapova 15000 23-may-07
    shrapova 20000 25-may-07
    shrapova 10000 28-may-07
    shrapova 12000 30-may-07

    from this table i want a query on 29-may-07.
    I want to know the balance for this particular date.

    Query: 2)
    id name city state
    100 sachin mumbai maharastra
    101 ganguli kolkatta bengal
    100 tendulkar mumbai maharastra

    from this table i need query output like

    100 sachin tendulkar mumbai maharashtra
    101 ganguli kolkatta bengal

    please forward this queries as soon as possible

    question asked by visitor raju

    Last edited by Geek_Guest; 06-14-2007 at 10:24 AM.

  2. #2
    Contributing Member
    Join Date
    May 2007

    Re: I want to know the balance for a particular date

    It is not possible to cretae query for u r second answer.....if u want the output like that u can write stored procedure.....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.