Function
/ *9. Write a SQL query to retrieve loan number, customer first name, customer last name,
property address, and bankruptcy attorney name. I want all the records that have the
same attorney name to be together, then the customer last name in order from Z-A
(ex.Customer last name of Wyatt comes before customer last name of Anderson)*/
Select LoanNumber,CustomerFname,C
From Loan
Group BY BankruptcyAttorneyName,Loa
Order by
LTrim(Reverse(Left(Reverse
CustomerLname Desc -- Fall-over for when there isn't a last name
Is it right comment?
property address, and bankruptcy attorney name. I want all the records that have the
same attorney name to be together, then the customer last name in order from Z-A
(ex.Customer last name of Wyatt comes before customer last name of Anderson)*/
Select LoanNumber,CustomerFname,C
From Loan
Group BY BankruptcyAttorneyName,Loa
Order by
LTrim(Reverse(Left(Reverse
CustomerLname Desc -- Fall-over for when there isn't a last name
Is it right comment?
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Since the last and first names are already separate, you probably don't need to reverse them or us any functions. And since you're not SUM'ing or doing any grouping functions, you don't need the GROUP BY, either. Ordering by the BankruptcyAttorneyName will group them in order:
SELECT LoanNumber,
CustomerFname,
CustomerLname,
Propertyaddress,
BankruptcyAttorneyName
FROM loan
ORDER BY BankruptcyAttorneyName,
CustomerLname DESC,
CustomerFname DESC,
LoanNumber
Select LoanNumber,CustomerFname,CustomerLname,Propertyaddress,BankruptcyAttorneyName
From Loan
Group BY BankruptcyAttorneyName,LoanNumber,CustomerFname,CustomerLname,Propertyaddress
Order by CustomerLname Desc
Premium Content
You need an Expert Office subscription to comment.Start Free Trial