I have this command:
select MAX(Price) from Sales where Time=19991010
When running done.It can be return 19991010 day's Max Price,But how to return The ID field corresponding Max Price in one command£¿
And another I Select from two table,there is two way:
How I choose it?
Thanks for you view!