Jump to content

Archived

This topic is now archived and is closed to further replies.

shan_cool

Display of records....

Recommended Posts

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..........

 

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.