SQL Most Asked Interview Questions || Part 01 || Select Query || SubString || Instr || Alias
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