i have the table then i display the half of the table only by using this query("SELECT TOP 50 PERCENT * FROM patient ORDER BY ID asc")
and also display only maximum of age only
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Santhosh Kumar JayaramanPosted Jan 21, 2013, 3:41 AM
SELECT TOP 50 PERCENT * FROM patient ORDER BY age desc