code

 How to reverse a string?

internal static void ReverseString(string str)  

{  

     

    char[] charArray = str.ToCharArray();  

    for (int i = 0, j = str.Length - 1; i < j; i++, j--)  

    {  

        charArray[i] = str[j];  

        charArray[j] = str[i];  

    }  

    string reversedstring = new string(charArray);  

    Console.WriteLine(reversedstring);  

    input: hello, output: olleh

input: hello world, output: dlrow olleh

Get Highest salary of 3 employee without using limit,and top SELECT StageID, DepartmentNumber, UserEmail ,DENSE_RANK() OVER (PARTITION BY DepartmentNumber ORDER BY UserEmail ASC) AS DRANK FROM mytable Get full name from First name and last name of table create view SELECT CONCAT (FirstName, ' , ' , LastName) AS fullname (salary*12)+(experience*500) AS total FROM staff var trans = transactions.OrderBy(t => t.PropertyName) .ThenBy(t => t.DifferentPropertyName) var trans = transactions.OrderByDescending(t => t.PropertyName) .ThenByDescending(t => t.DifferentPropertyName)