Window Functions in SQL

Problem :

I need to rank the rows based on serial number and the serial numbers should be ranked based on the latest inspection date. I have duplicate serial numbers in my data set. How to Achieve.

Solution :

you can use any of the below method to achieve without using Partition

SQL Query - Dense_Rank() over (order by InspectionDate desc, SerialNumber) as row_num

Comments

Convex Lens Vs Concave Lens

What is a Lens A lens is a transparent object that transmits light across it, and its working principle depends on the law of refraction (Snell’s law) . Applications: Concave Lens help with Far-Sight Convex Lens help with Near-Sight

Herbal Plants

Herbal plants to grow in home Different types of keerai ----- http://www.indiandietrecipes.com/2016/03/pictures-of-various-types-of-greens-or.html Pirandai ----good for bone joins---- https://youtu.be/k2DGubyXLAE Valarai Keerai Benifits ----- https://youtu.be/33HIfLJKTqA Sesma seeds ---- https://easyayurveda.com/2011/02/24/sesame-and-sesame-oil-benefits-total-ayurveda-details/

What is Verbal and Non-Verbal communication

TYPES OF COMMUNICATIONS:

Karthi Blog

Search This Blog