Sir, firstly thank you so much for posting this video, its really helpful and I have learned a new function today..I have a clarification, insted of numaric values, for example if we are applying LEAD function on DATE column syntax explained above is not working... can you please help
I want to see employee name with minimum salary in the department whenever a new employee joins(i.e. order by joining date). Upto minimum salary, its OK to get it with analytical function SQL- select e.first_name,e.last_name,e.hire_date,e.department_id,e.salary , min(e.salary) over(partition by e.department_id order by e.hire_date) min from HR.employees e order by 1,2 But can i get the employee name without using self join Example- First_name,joiningDate,Department_id,min_sal,min_sal_employee A,1-March-2019,1,500,500,A B,2-March-2019,1,400,400,B C,3-March-2019,1,600,400,B C,4-March-2019,1,1000,400,B
I had to learn two things at the same time. The tech stuff and your language. Please consider going back to English school for grammar and pronunciation.
You don't know about him... Go to Hyderabad and ask any one who is Murli sir, For those who are not good in English they can easily understand. So please keep shut your mouth up 😄
Thank you. I understood KEEP function just because of this video
Sir, firstly thank you so much for posting this video, its really helpful and I have learned a new function today..I have a clarification, insted of numaric values, for example if we are applying LEAD function on DATE column syntax explained above is not working... can you please help
good explanation Sir. thank you for sharing knowledge .
very good sir, thank you so much ..you have explained very very good
Great Explanation
YOUR VIDEO ALWAYS GOOD
Good Explanation sir,keep going on......................
Very good Sir, Helped a lot
Great explaination. Thank you
Thank you
Very good explanation sir
My favourite sir.........
good explanation sir keep in progress
Thanks sir 👍
good explanation sir
We can easily say he's a telungu guy by his English pronunciations.
Thank you sir
fantastic
Sir, i want to see last three purchase rate
My table has item_name, vrno,vrdate,rate
I want to see employee name with minimum salary in the department whenever a new employee joins(i.e. order by joining date).
Upto minimum salary, its OK to get it with analytical function
SQL-
select e.first_name,e.last_name,e.hire_date,e.department_id,e.salary ,
min(e.salary) over(partition by e.department_id order by e.hire_date) min
from HR.employees e order by 1,2
But can i get the employee name without using self join
Example-
First_name,joiningDate,Department_id,min_sal,min_sal_employee
A,1-March-2019,1,500,500,A
B,2-March-2019,1,400,400,B
C,3-March-2019,1,600,400,B
C,4-March-2019,1,1000,400,B
Do you have a sql to compare records by a unique person monthly....??????????????
using first_value we can get result... again why First???
sir will share me joins topics
I liked first
I had to learn two things at the same time. The tech stuff and your language. Please consider going back to English school for grammar and pronunciation.
You don't know about him... Go to Hyderabad and ask any one who is Murli sir, For those who are not good in English they can easily understand.
So please keep shut your mouth up 😄
thank you sir