simple query

• Maverick100877

  SSCertifiable

  Points: 5240

  More actions

  November 27, 2006 at 11:39 pm

  #121677

  Hi

  Well I have a table employeemst which has the employeeid,employeename,salaray fields.

  Now I want to find out the name of the employee who is having the maximum salary. I know this is pretty simple but how do I go about it.

   

  One way is to

  select top 1 employeename from employeemst order by salaray desc

   

  is this the best way to do it or is there any other way out.

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  November 28, 2006 at 2:13 am

  #674260

  select employeename from employeemst where salaray = (select max(salaray) from employeemst.

  ur way seems to be good enough though

  "Keep Trying"