38.Consider a table SALESMAN with the following data: [5]
SNO SNAME SALARY BONUS DOJ
A01 Beena Mehta 30000 45.23 29-10-2019
A02 K. L. Sahay 50000 25.34 13-03-2018
B03 Nisha Thakkar 30000 35.00 18-03-2017
B04 Leela Yadav 80000 NULL 31-12-2018
C05 Gautam Gola 20000 NULL 23-01-1989
C06 Trapti Garg 70000 12.37 15-06-1987
D07 Neena Sharma 50000 27.89 18-03-1999
Write SQL queries using SQL functions to perform the following operations:
1. To Display salesman name and salary whose salary is more than 25000.
2. To Display SNAME and SALARY of salesman no is D07 only.
3. To Display youngest salesman DOJ.
4. To Display minimum salary among all salesman.
5. To Display salesman name staring from L character.
Answers
Answered by
0
38.Consider a table SALESMAN with the following data: [5]
SNO SNAME SALARY BONUS DOJ
A01 Beena Mehta 30000 45.23 29-10-2019
A02 K. L. Sahay 50000 25.34 13-03-2018
B03 Nisha Thakkar 30000 35.00 18-03-2017
B04 Leela Yadav 80000 NULL 31-12-2018
C05 Gautam Gola 20000 NULL 23-01-1989
C06 Trapti Garg 70000 12.37 15-06-1987
D07 Neena Sharma 50000 27.89 18-03-1999
Write SQL queries using SQL functions to perform the following operations:
1. To Display salesman name and salary whose salary is more than 25000.
2. To Display SNAME and SALARY of salesman no is D07 only.
3. To Display youngest salesman DOJ.
4. To Display minimum salary among all salesman.
5. To Display salesman name staring from L character.
Similar questions