SQL Most Asked Interview Questions || Part 01 || Select Query || SubString || Instr || Alias

Sdílet
Vložit
  • čas přidán 5. 09. 2024
  • Hello Learners :),
    please mail on studentforyou07@gmail.com for any query .
    Please find Below queries are solved in this tutorial :
    • Fetech First_Name, Last_Name from employee table
    • Fetech Last_Name from employee table using alias name “Employee Name”
    • Fetch First_name, salary , salary*1.5 as new salary
    • Fetch the employee details whose last name is gupta
    • Fetech First_Name from employee table in upper case
    • Fetech FIRST_NAME from employee table in lower case
    • Get unique DEPARTMENT from employee table
    • Get first 3 characters of FIRST_NAME from EMPLOYEE
    • Get position of ‘o’ in name ‘sohan’ from employee table
    • Get FIRST_NAME from employee table after removing white spaces from right side?
    • Get FIRST_NAME from employee table after removing white spaces from left side?
    #sql #sqlinterviewquestionsandanswers #sqlinterviewquestions #sqlinterview#oracle #sqlquery #development #interview #sqlserver

Komentáře •