डेटा प्राप्त करना
Oracle SQL परिचय
Sara Billen
Curriculum Manager
आउटपुट कस्टमाइज़ करना
- डुप्लिकेट हटाएँ
- स्ट्रिंग्स में बदलाव करें
- अरिथमेटिक एक्सप्रेशन
- डेटा को ऑर्डर करें
DISTINCT
SELECT BillingCountry
FROM Invoice
| BillingCountry |
|----------------|
| Germany |
| Germany |
| USA |
| Norway |
| ... |
* 412 rows selected
SELECT DISTINCT BillingCountry
FROM Invoice
| BillingCountry |
|----------------|
| Germany |
| Norway |
| USA |
| ... |
* 24 rows selected
स्ट्रिंग्स में बदलाव - कंकैटिनेशन ऑपरेटर
SELECT FirstName || LastName
FROM Customer
| FirstName || LastName |
|-----------------------------|
| FrankHarris |
| HannahSchneider |
| LucasMancini |
| ... |
स्ट्रिंग्स में बदलाव - लिटरल कैरेक्टर स्ट्रिंग्स
SELECT 'Full name: ' || FirstName || ' ' || LastName
FROM Customer
| 'Full name: ' || FirstName || ' ' || LastName |
|-----------------------------------------------|
| Full name: Frank Harris |
| Full name: Hannah Schneider |
| Full name: Lucas Mancini |
| ... |
स्ट्रिंग्स में बदलाव - वैकल्पिक क्वोट ऑपरेटर
SELECT LastName || ': This employee's title is: ' || Title
FROM Employee
syntax error at or near "title"
LINE 1: SELECT LastName || ': This employee's title is: ' || Title
स्ट्रिंग्स में बदलाव - वैकल्पिक क्वोट ऑपरेटर
SELECT LastName || q'[: This employee's title is: ]' || Title
FROM Employee
| LastName || q'[, this employee's title is: ]' || Title |
|--------------------------------------------------------|
| Adams: This employee's title is: General Manager |
| Edwards: This employee's title is: Sales Manager |
| Park: This employee's title is: Sales Support Agent |
| King: This employee's title is: IT Staff |
| ... |
अरिथमेटिक एक्सप्रेशन
अरिथमेटिक ऑपरेटर से number और date वैल्यू पर एक्सप्रेशन बनाएँ.
| Operator | Description |
|---|---|
| + | जोड़ |
| - | घटाव |
| * | गुणा |
| / | भाग |
अरिथमेटिक एक्सप्रेशन
SELECT TrackName, Milliseconds, Milliseconds / 1000
FROM Track
| TrackName | Milliseconds | Milliseconds / 1000 |
|--------------------------|--------------|---------------------|
| Killer Queen | 182099 | 182.099 |
| Smells Like Teen Spirit | 301296 | 301.296 |
| The Star Spangled Banner | 43232 | 43.232 |
| With Or Without You | 299023 | 299.023 |
पंक्तियाँ ऑर्डर करना
SELECT LastName, Title, City, HireDate
FROM Employee
ORDER BY HireDate
| LastName | Title | City | HireDate |
|----------|-----------------------|------------|---------------------|
| Peacock | Sales Support Agent | Calgary | 2002-04-01 00:00:00 |
| Edwards | Sales Manager | Calgary | 2002-05-01 00:00:00 |
| Adams | General Manager | Edmonton | 2002-08-14 00:00:00 |
| Park | Sales Support Manager | Calgary | 2003-05-03 00:00:00 |
| Johnson | Sales Support Agent | Calgary | 2003-10-17 00:00:00 |
| Mitchell | IT Manager | Calgary | 2003-10-17 00:00:00 |
| King | IT Staff | Lethbridge | 2004-01-02 00:00:00 |
| Callahan | IT Staff | Lethbridge | 2004-03-04 00:00:00 |
पंक्तियाँ ऑर्डर करना
घटते क्रम में ऑर्डर करें:
SELECT LastName, Title, City, HireDate
FROM Employee
ORDER BY HireDate DESC
कई कॉलम से ऑर्डर करें:
SELECT LastName, Title, City, HireDate
FROM Employee
ORDER BY City, HireDate
अभ्यास करते हैं!
Oracle SQL परिचय
