How can you return all the records from a table named "Persons" - ProProfs Discuss
Advertisement

How can you return all the records from a table named "Persons" sorted descending by "FirstName" with SQL?

How can you return all the records from a table named "Persons" sorted descending by "FirstName" with SQL?<br/>

Change Image    Delete

Asked by Maghzi, Last updated: Nov 09, 2024

+ Answer
Request
Question menu
Vote up Vote down

2 Answers

E. Austin

E. Austin

E. Austin
E. Austin

Answered Dec 14, 2018

A commonly asked question by SQL users or those learning how to use SQL is if you can return all the records from a table named "Persons" sorted descending by "FirstName" with SQL? The answer is yes you can!

In order to return all the records from a table named "Persons" sorted descending by "FirstName" using SQL, you must SELECT FROM Persons ORDER BY FirstName DESC. SQL is a type of computing language that is used to communicate with databases. It is similar to a computer language but it is only specifically used for databases.

upvote downvote
Reply 

John Smith

John Smith

John Smith
John Smith

Answered Dec 10, 2016

SELECT * FROM Persons ORDER BY FirstName DESC
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.