Lead , Lag , First Value , Last Value , Keep First , Keep Last | Oracle SQL Tutorial | Mr.Murali

Подписаться 1,3 млн

Просмотров 54 тыс.

50% 1

Lead , Lag , First Value , Last Value , Keep First , Keep Last in Oracle SQL | Oracle SQL Tutorial | Mr.Murali
►For Registration : goo.gl/r6kJbB ►Call: +91-8179191999
► Visit Our Website:
nareshit.in/
nareshit.com/
► About NareshIT:
"Naresh IT is the Best Software Training Institute for Hadoop, Salesforce, AWS, DevOps, Sprak, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in Hyderabad, Chennai and Vijayawada, India which provides online and classroom training classes"
►For Registration : goo.gl/r6kJbB
►Call:
India- 8179191999, USA- 404-232-9879
Email: online@nareshit.com
►Our Online Training Features:
1.Training with Real-Time Experts
2.Industry Specific Scenario’s
3.Flexible Timings
4.Soft Copy of Material
5.Share Video's of each and every session.
Check The Below Links:
►For Course Reg : goo.gl/r6kJbB
► Subscribe to Our Channel: goo.gl/q9ozyG
► Circle us on G+: plus.google.co...
► Like us on Facebook: / nareshit
► Follow us on Twitter: / nareshitech
► Visit Our Website:
nareshit.in/
nareshit.com/

Опубликовано:

29 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 28

@prashanth1011 Год назад

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

@maheshbabumagipogu9199 2 года назад

thank you sir

@edukondalumuchumuri6890 6 лет назад

Good Explanation sir,keep going on......................

@patilvishwajit 5 лет назад

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

@maheshwarreddyk1250 6 лет назад

sir will share me joins topics

@raghavendranramachari488 4 года назад

Thank you. I understood KEEP function just because of this video

@psjandyala 5 лет назад

good explanation Sir. thank you for sharing knowledge .

@aruljebin 4 года назад

We can easily say he's a telungu guy by his English pronunciations.

@axelfoley7154 6 лет назад

Do you have a sql to compare records by a unique person monthly....??????????????

@gyananayak7679 4 года назад

Sir, i want to see last three purchase rate My table has item_name, vrno,vrdate,rate

@dineshkhairnar1340 4 года назад

very good sir, thank you so much ..you have explained very very good

@besttube2401 6 лет назад

using first_value we can get result... again why First???

@kumar-bi1to 2 года назад

Thank you

@parthparth8680 3 года назад

YOUR VIDEO ALWAYS GOOD

@JamirUddinBhuiyan 3 года назад

fantastic

@KrishnaPaneri 4 года назад

Great explaination. Thank you

@pankajkharade6936 3 года назад

Great Explanation

@swapnaram8799 4 года назад

Thanks sir 👍

@vishnudahiphale7911 6 лет назад

Very good explanation sir

@sasitharan1436 6 лет назад

good explanation sir keep in progress

@sunilcahvan 6 лет назад

Very good Sir, Helped a lot

@swapnavallepu2029 5 лет назад

Thank you sir

@srinukunta3917 6 лет назад

good explanation sir

@tarakantabaral4061 6 лет назад

My favourite sir.........

@raviteja9710 6 лет назад

I liked first

@TheHarishAgarwal 3 года назад

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.

@akashsoni6419 Год назад

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 😄