Database

select latest_order.customer_id AS cust_id
      latest_order.order_id AS order_id,
      customers.fname AS fname,
      customers.lname AS lname,
      latest_order.order_date AS order_date,
      latest_order.order_status AS order_status
from customers
inner join (
   select lastest_order_id.customer_id, lastest_order_id.order_id,
      lastest_order_id.order_date, latest_order_id.order_status
   from (
      select customer_id, max(order_id)
      from cust_order
      group by customerId
   ) as lastest_order_id
   inner join cust_order
   on cust_order.order_id = lastest_order_id.order_id
) as latest_order
on latest_order.customer_id = customers.customer_id

Blue_Boy wrote:

select convert(varchar,ExamTime,108)

I was born dumb!!
Programming made me laugh !!!
--sid--

SELECT s.sno, s.name, m.desc
FROM MyTable AS m
INNER JOIN (SELECT MAX(sno) AS sno, name FROM MyTable GROUP BY name) AS s
ON s.sno = m.sno AND s.name = m.name

PrakashBhaskar wrote:

for this you have to use corolated queries following the example

SELECT sno, name, desc FROM <table name> WHERE sno=(SELECT MAX(sno) FROM <table mame)

I think ur problem has solved