Software Applications Programming Errors and solutions.

To write query second highest salary in for Employee in SQL there are many way to achieve this I am sharing here some sample examples. Select * from(select deptno,sal,dense_rank() over (partition by deptno order by sal desc)r from emp) where r=2 select empno,ename,sal,deptno, row_number() over(partition by deptno order by sal desc)rn from emp )select * from cte where rn=2 Select max(sal)from emp  Where sal <(select max(sal) from emp) Select deptno, max(salary) from(Select a.deptno,a.salary from employee a, (Select deptno,max(salary) from employee group by deptno) b where a.deptno=b.deptno And a.salary<b.salary) group by deptno;

To get Last 10 records from SQL table you can get idea from below example. You can try that by rounum condition. select * from emp minus select * from emp where rownum<=(select count(*)-10 from emp); or you can try this also. select * from ( select * from emp  order by empno desc) where rownum<=10

The question is How get middle name from full name column in SQL Table? Full name can be like this. Santosh kumar singh Raj Narayan verma Middle name is Kumar and Narayan etc. Solution. Use instr to get the position of first space and second space.use substr to get the string from first space +1 to 2nd space - 1. I hope you will get solution. Example.  Using substr function it will get the result of middle names. Substr(colname,instr(colname, ' ', 1,1),instr(colname,' ' , -1,1))

Getting below Error during Code Upgrade Ax 2012 from R2 to R3 . Can you suggest to resolve these errors. Description The first enabled data source(ProjForecastEmplView_1) in union query cannot have disabled field(Qty). Menu item RETAILLOYALTYCUSTTABLE does not exist. Menu item RETAILLOYALTYCUSTTABLE does not exist. Duty DOCommerceOnlineSalesOrdersMaintain does not exist. The first enabled data source(RetailTransactionTable_1) in union query cannot have disabled field(transactionId). Menu item RETAILLOYALTYMSRCARDTRANS does not exist. Menu item RETAILLOYALTYCUSTTABLE does not exist. Menu item RETAILLOYALTYCUSTTABLE does not exist. Menu item RETAILLOYALTYCUSTTABLE does not exist. Menu item InventAging_CN does not exist. Menu item RETAILLOYALTYMSRCARDTRANS does not exist. The class 'FormRun' does not contain the method 'isRetailAttribute'. The RetailPricingEngine::setRetailDiscountsOnOrder method is obsolete. Use method calculateIndependentPriceDiscounts in

Visio 2010 (Multiple Editions) with Service Pack 1 Visio 2013 Professional Visio 2013 Service Pack 1 Visio Professional 2016 Visio Professional 2019 Visio Standard 2013 Visio Standard 2016 Visio Standard 2019 Visio Tools SDK and DDKs Visual Basic .NET 2003 Visual Basic 2.0 Visual Basic 2.0 Professional Visual Basic 2.0 Standard Visual Basic 3.0 Professional Visual Basic 4.0 Visual Basic 6.0 Code Advisor Visual Basic 6.0 Enterprise Visual Basic for Applications Visual C++ 1.52 Visual C++ 2.0 Visual C++ 2010 Redistributable Package Visual C++ 2010 Service Pack 1 Redistributable Package Visual C++ 2015 Redistributable Visual C++ 2015 Redistributable Update 3 Visual C++ 4.2 Enterprise Visual C++ Browser Toolkit Visual C++ Build Tools 2015 Update 2 Visual C++ Build Tools 2015 Update 3 Visual C++ Redistributable for Visual Studio 2012 Visual C++ Redistributable for Visual Studio 2012 Update 3 Visual C++ Redistributable for Visual Studio 2012 Update 4 Visual C+

Windows 10 (business edition), version 1803 (updated Aug 2018) Windows 10 (business edition), version 1803 (updated Sept 2018) Windows 10 (business editions), version 1803 (updated April 2019) Windows 10 (business editions), version 1803 (updated Jan 2019) Windows 10 (business editions), version 1803 (updated July 2018) Windows 10 (business editions), version 1803 (updated July 2019) Windows 10 (business editions), version 1803 (updated June 2019) Windows 10 (business editions), version 1803 (updated March 2018) Windows 10 (business editions), version 1803 (updated March 2019) Windows 10 (business editions), version 1803 (updated May 2019) Windows 10 (business editions), version 1809 (updated April 2019) Windows 10 (business editions), version 1809 (updated Dec 2018) Windows 10 (business editions), version 1809 (updated Feb 2019) Windows 10 (business editions), version 1809 (updated Jan 2019) Windows 10 (business editions), version 1809 (updated July 2019) Windows 10 (b

Office 2003 Professional Office 2003 Professional Enterprise Office 2003 Proofing Tools Office 2003 SDK and DDKs Office 2003 Service Pack Office 2003 Standard Office 2007 Enterprise Office 2007 Language Pack Office 2007 Professional Office 2007 Professional Plus Office 2007 Proofing Tools Office 2007 SDK Office 2007 Service Pack Office 2007 Standard Office 2007 Ultimate Office 2010 Language Pack Office 2010 Proofing Tools Office 2010 Service Pack 1 Office 2010 Service Pack 2 Office 2013 Language Pack Office 2013 Language Pack with Service Pack 1 Office 365 Office 95 Professional Office Accounting 2007 SDK Office Accounting Express Office Accounting Professional Office Accounting Service Pack Office Communications Server 2007 Enterprise Office Communications Server 2007 R2 Enterprise Office Communications Server 2007 R2 Standard Office Communications Server 2007 Standard Office Communicator 2005 Office Communicator 2007 Office Communicator 2007 R2 Offi