How to find Maximum Marks Scored by Person without Using Aggregation Function?
By: Sugandh | 14 May 2015 4:07 pm | 482 times viewed | 0 Comments
I have this query: name =x marks =90,name=y marks =80,name =z marks =70 table name = student.
My question is how to find maximum marks scored by person without using aggregation function!?
Please assist here, Thanks in advance.
No Comments Posted for this Article.
10 Tips to Make Million Bucks from SAP as a CareerWell there are a couple of ways through which you can surely make millions in your career in SAP. SAP(Systems, Applications, Products in Data Processing) is a niche area and these days the skill is very much in demand. Thanks to technology now you can certainly be a millionaire in not much time...
SAP comes to Rescue Indian RailwaysIndian railways were originally founded in the year 1853 and now are known as the largest rail network in Asia. It is interesting to know that there are more than 6000 stations and almost 20 million passengers travel daily through trains. Apart from being a favored mode of transport, the...
Cancer Fight: TreatmentMAP Uses SAP HANATreatmentMAP, an innovative technology developed by Molecular Health, a German biotech company, has won the prestigious SAP Hana Technology Trailblazer Award at Sapphire Now. This award is bestowed upon the company that uses Internet of Things” and big data in its applications, to achieve...
Top 10 Highest Paid SAP Companies in UK in 2015Though there are numerous companies in the industry that provide SAP solutions and other related services to their global clients, not all of them shine equally in the field. The major reason is variation in the efficiency of the employees and working flexibility. The organizations which are able...
Enterprise Structure Related SAP FICO Interview Questions and AnswersFAQ: Enterprise Structure related SAP FICO What are the various organizational assignments to a company code?Company Code is a legal entity for which financial statements like Profit and Loss and Balance Sheets are generated. Plants are assigned to the company code, Purchasing organization is...
How to implement Over partion by in DS
Hi guysI have a code which is in oracle sql and I want to translate a partition by and get a minimum as shown below how can I do this in bods . the code is belowselect...
SQL Financial Accounting Error..
Hi all, I have one problem regarding the SQL financial accounting software.When i run this software,it display this message: Exception EAccessViolation in module SQLAcc.exe at 000041f1 Access...
How to Unlock SAP* in SQL Database Windows.
Hello Experts How to unlock sap* in sql database windows. In my landscape PI production system 000 client all the user's got locked due to incorrect password. Kindly help me with some...