Sorting Results Using ORDER BY Propert

1 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$99.99
List Price:  $139.99
You save:  $40
€93
List Price:  €130.20
You save:  €37.20
£80.04
List Price:  £112.06
You save:  £32.01
CA$137.46
List Price:  CA$192.45
You save:  CA$54.99
A$152.16
List Price:  A$213.03
You save:  A$60.87
S$135.55
List Price:  S$189.78
You save:  S$54.22
HK$781.57
List Price:  HK$1,094.24
You save:  HK$312.66
CHF 90.85
List Price:  CHF 127.19
You save:  CHF 36.34
NOK kr1,092.22
List Price:  NOK kr1,529.15
You save:  NOK kr436.93
DKK kr693.66
List Price:  DKK kr971.15
You save:  DKK kr277.49
NZ$166.97
List Price:  NZ$233.77
You save:  NZ$66.79
د.إ367.25
List Price:  د.إ514.17
You save:  د.إ146.91
৳10,995.41
List Price:  ৳15,394.02
You save:  ৳4,398.60
₹8,350.38
List Price:  ₹11,690.87
You save:  ₹3,340.48
RM474.20
List Price:  RM663.90
You save:  RM189.70
₦140,430.95
List Price:  ₦196,608.95
You save:  ₦56,178
₨27,811.82
List Price:  ₨38,937.66
You save:  ₨11,125.84
฿3,694.61
List Price:  ฿5,172.60
You save:  ฿1,477.99
₺3,225.42
List Price:  ₺4,515.72
You save:  ₺1,290.29
B$507.43
List Price:  B$710.43
You save:  B$202.99
R1,857.85
List Price:  R2,601.07
You save:  R743.21
Лв182.19
List Price:  Лв255.08
You save:  Лв72.88
₩136,210.38
List Price:  ₩190,699.98
You save:  ₩54,489.60
₪370.57
List Price:  ₪518.82
You save:  ₪148.24
₱5,735.07
List Price:  ₱8,029.33
You save:  ₱2,294.25
¥15,537.84
List Price:  ¥21,753.60
You save:  ¥6,215.76
MX$1,691.01
List Price:  MX$2,367.48
You save:  MX$676.47
QR364.06
List Price:  QR509.70
You save:  QR145.64
P1,360.66
List Price:  P1,904.98
You save:  P544.31
KSh13,098.69
List Price:  KSh18,338.69
You save:  KSh5,240
E£4,756.64
List Price:  E£6,659.49
You save:  E£1,902.84
ብር5,704.16
List Price:  ብር7,986.06
You save:  ብር2,281.89
Kz83,693.62
List Price:  Kz117,174.42
You save:  Kz33,480.80
CLP$93,652.63
List Price:  CLP$131,117.43
You save:  CLP$37,464.80
CN¥722.46
List Price:  CN¥1,011.48
You save:  CN¥289.01
RD$5,816.45
List Price:  RD$8,143.26
You save:  RD$2,326.81
DA13,451.28
List Price:  DA18,832.33
You save:  DA5,381.05
FJ$227.46
List Price:  FJ$318.45
You save:  FJ$90.99
Q778.38
List Price:  Q1,089.77
You save:  Q311.38
GY$20,959.74
List Price:  GY$29,344.48
You save:  GY$8,384.73
ISK kr13,978.60
List Price:  ISK kr19,570.60
You save:  ISK kr5,592
DH1,004.51
List Price:  DH1,406.36
You save:  DH401.84
L1,772.88
List Price:  L2,482.10
You save:  L709.22
ден5,732.06
List Price:  ден8,025.12
You save:  ден2,293.05
MOP$807.08
List Price:  MOP$1,129.95
You save:  MOP$322.86
N$1,848.73
List Price:  N$2,588.30
You save:  N$739.56
C$3,687.79
List Price:  C$5,163.05
You save:  C$1,475.26
रु13,385.83
List Price:  रु18,740.70
You save:  रु5,354.86
S/373.68
List Price:  S/523.18
You save:  S/149.49
K387.85
List Price:  K543
You save:  K155.15
SAR374.99
List Price:  SAR525.01
You save:  SAR150.01
ZK2,715.07
List Price:  ZK3,801.21
You save:  ZK1,086.13
L462.80
List Price:  L647.94
You save:  L185.14
Kč2,329.86
List Price:  Kč3,261.90
You save:  Kč932.03
Ft36,210.88
List Price:  Ft50,696.68
You save:  Ft14,485.80
SEK kr1,090.42
List Price:  SEK kr1,526.63
You save:  SEK kr436.21
ARS$88,067.42
List Price:  ARS$123,297.91
You save:  ARS$35,230.49
Bs691.01
List Price:  Bs967.44
You save:  Bs276.43
COP$390,100.45
List Price:  COP$546,156.24
You save:  COP$156,055.78
₡51,233.50
List Price:  ₡71,728.95
You save:  ₡20,495.44
L2,475.71
List Price:  L3,466.09
You save:  L990.38
₲747,614.58
List Price:  ₲1,046,690.32
You save:  ₲299,075.74
$U3,836.09
List Price:  $U5,370.68
You save:  $U1,534.59
zł401.29
List Price:  zł561.83
You save:  zł160.53
Already have an account? Log In

Transcript

Hello, in this video, we are going to take a look at sorting results. So 14 results essentially what we want to do or what we can do. And what we will do in this video is we'll get the username, and we'll sorted based on that. So you'll be ascending and descending will show you both to sorted really simple, you go to query your order by then the column that you are essentially ordering. So in my case, it's user name, and then afterwards you put ASC or de SC for ascending and descending for reload that it goes ascending. So be calm before F and F become four Why?

If I put D and C which is decent, it you will basically reverse the order. So b three, one and two, like so. And that's it. You can do it on any column and it also something called several column ordering. And I want you to do as an extra task is have a look of finding out what that is and how to improve Apart from that, then nothing else to 14 results. Thanks for watching and I look forward to seeing you in the next video.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.