Interested to Buy Any Domain ? << Click Here >> for more details...
how to find 2nd highest salary in random database salary of employer.....
- 4 Answers
- 7179 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajasekhar.s
select distinct a.sal from emp a where
n=(select count(distinct b.sal)
from emp b where a.sal<=b.sal)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is mysqlcheck do?
Can foreign key have duplicate values?
What is difference between oracle sql and mysql?
How to filter data from a mysql database table with php?
how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.
Explain the different types of mysql joins.
What is triggers?
What is mysql aggregate functions? Explain
What is blob and text in mysql?
What are the technical features of MySQL?
Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END
Is mysql better than oracle?
How do I start mysql manually?
How to Join tables on common columns.
What is a definer?
