Re: SQl Query help

Results 1 to 2 of 2

Thread: Re: SQl Query help

  1. #1
    Join Date
    Dec 1969

    Default Re: SQl Query help

    hi,<BR> <BR>i have a table named <BR><BR>jobs which has the 2 fields<BR>=======<BR><BR>jobtitle, jobno<BR><BR>what i wanted to do is i wanted to get the count of each job and display it according in the desc order.of the job count. <BR><BR><BR>SELECT COUNT(jobno), job_Title FROM USERJOB GROUP BY job_title ORDER BY job_title"<BR><BR>i want to get the count(jobno) in asc order<BR><BR>any help would be appreciated<BR><BR>thanks<BR>sam

  2. #2
    Join Date
    Dec 1969

    Default what?

    you want to display the count, then the job no. descending and the job desc ascending???<BR><BR>wanna re-phrase your question??<BR><BR>j

Posting Permissions

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