Hi,
   
   
  Can anybody help me out..
   
   I want a query that fetches for records based on criteria which has to 
include a column represeting the count.
   
  e.g. select ...,empno,ename from employee where basic>5000
  result should be 
  s.no.      empno     ename
  1           E001      xyz
  2           E450      x1
  3           E560      z1
  ..
  like that..
   
  thanks in advance
   
  regards
  access_MK

                
---------------------------------
New Yahoo! Messenger with Voice. Call regular phones from your PC and save big.

[Non-text portions of this message have been removed]



 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/ms_access/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 



Reply via email to