Nth Highest Salary

Create table #tblEmployee (Id int, [Name] varchar(100), City varchar(100), Salary decimal (10,3)) Insert into #tblEmployee values(1, ‘Prakash Rathod’, ‘Gandhinagar’, 100000) Insert into #tblEmployee values(2, ‘Salman Khan’, ‘Mumbai’, 100000) Insert into #tblEmployee values(3, ‘Aamir Khan’, ‘Mumbai’, 90000) Insert into #tblEmployee values(4, ‘Katrina Kaif’, ‘Mumbai’, 80000) Insert into #tblEmployee values(5, ‘Rashmi Bansal’, ‘Indor’, 95500) Insert into #tblEmployee …

Read More

Generate x509 certificate in pem, cer and pfx and export public key

Generate x509 cerntifcate c:\Demo>openssl req -x509 -days 365 -newkey rsa:2048 -keyout my-key.pem -out -my-cert.pem Generating a RSA private key ………………………+++++ …………..+++++ writing new private key to ‘my-key.pem’ Enter PEM pass phrase: Verifying – Enter PEM pass phrase: —– You are about to be asked to enter information that will be incorporated into your certificate request. …

Read More