Jump to content


Photo

Pbm with display of recors


  • Please log in to reply
No replies to this topic

#1 shan_cool

shan_cool
  • Members
  • PipPipPip
  • Advanced Member
  • 53 posts
  • LocationChennai,India

Posted 03 December 2005 - 07:47 AM

Hi all,
I need to dispaly a set of records in ascending order..

I hav given the query as:
Select * From Emp_Det where Emp_Id like '$Emp_Id%' and Emp_Status <> 'R' order by Emp_Id ASC

It displays:
EmployeeId Name
1 Ranga
10 Sajan C K
101 Sridevi
112 Niraj
198 Florence Lavanya
199 M.Subbarao
2 N N Subramanian
20 Rosario

but i neeed to display it as:
EmployeeId Name
1 Ranga
2 N N Subramanian
10 Sajan C K
20 Rosario
101 Sridevi
112 Niraj
198 Florence Lavanya
199 M.Subbarao

plz help me out to change it....
shan,
chennai,
India..........





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users