Sort command in DBMS in hindi – Single and Multiple key sorting

Sort commands, chahe single key ya multiple key, data ko ek nirdisht kram mein vyavasthit karne ke liye istemal kiye jaate hain.

Sort command in DBMS in hindi – Single and Multiple key sorting

DBMS के ये Topics के बारे में जानें :-

Aaiye single key aur multiple key sorting ke concept ko samjhein:

  1. Single Key Sorting: Single key sorting mein data ko ek hi attribute (key) ke aadhar par vyavasthit kiya jata hai. Records uss vishesh key ke aadhar par badhane (ascending) ya ghatane (descending) ke kram mein sort kiye jaate hain. Jaise ki, ek naam ki list ko aksharik kram mein sort karna ya ek sankhya ki list ko sankhyatmak kram mein sort karna. Single key sorting tab kaam aata hai jab aap data ko kisi ek vishesh attribute ke adhar par vyavasthit karna chahte hain.

  2. Multiple Key Sorting: Multiple key sorting mein data ko ek se adhik attributes (keys) ke aadhar par vyavasthit kiya jata hai. Records ko ek nirdisht kram mein sort kiya jata hai, jisme multiple keys ke values ka dhyan rakha jata hai. Is prakar ke sorting se data ko vyapak tarike se vyavasthit kiya ja sakta hai. Jaise ki, aap ek karmchari ki suchi ko pehle vibhag aur phir vetan ke aadhar par sort kar sakte hain. Multiple key sorting data ko hirarkiyal kram mein vyavasthit karta hai.

Dono, single key aur multiple key sorting mein, sort command data ko padhta hai, nirdisht key(s) ke values ko tulnatmak roop se tulya, aur records ko uss anusaar vyavasthit karta hai. Sort ki gayi data nayi file mein store ki ja sakti hai ya fir aur prakriya ya tajkiya ke liye prastut ki ja sakti hai.

Data ko sort karna, information ko vyavasthit karne aur prapt karne mein sahayak hota hai. Ye data analysis, khoj, aur reporting ko aasan banata hai. Chahe single key ya multiple keys ka upyog ho, sort commands data ko nirdisht maano mein vyavasthit karne ka ek tarika pradaan karte hain.

1 thought on “Sort command in DBMS in hindi – Single and Multiple key sorting”

Leave a Comment