Query in sqlserver 2005 to display records

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

, +

Good Evening ,

I have large number of data in sqlserver 2005 database , and

How to write a query in sqlserver 2005, to display the records alphabets wise.(a-z)

Thanx Experts.

Posted 16-Jul-12 23:54pm

Software Engineer 892

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2012-07-17T00:03:00

Solution 2

You need to use the order by clause to order records in a query.

Posted 17-Jul-12 0:03am

Abhinav S

Comments

k@ran 17-Jul-12 6:07am

select * from employee to view record and
select * from employee order by emp_name asc|desc

jasmin_patel · Answer 2 · 2012-07-17T00:01:00

Solution 1

SQL

SELECT EMPLOYEE_NAME FROM EMPLOYEE_MASTER ORDER BY EMPLOYEE_NAME ASC

Posted 17-Jul-12 0:01am

jasmin_patel

StianSandberg · Answer 3 · 2012-07-17T00:06:00

Solution 3

Use of "ORDER BY" in t-sql sorts your records. You can read more about it here http://www.w3schools.com/sql/sql_orderby.asp[^]

SQL

SELECT * FROM [Table] ORDER BY [Column] ASC

Or the other way

SQL

SELECT * FROM [Table] ORDER BY [Column] DESC

If you have a large number of records you may consider indexing that column. http://www.sql-server-performance.com/2007/optimizing-indexes-general/[^]

Posted 17-Jul-12 0:06am

StianSandberg

Comments

Ranjith Reddy CSE 17-Jul-12 6:25am

SqlDataAdapter dad3 = new SqlDataAdapter("select ClearanceNumber, CodeFlightId, DateLastChange, DateValidFrom,"
+ "DateValidTo, ReservationNo, AircraftType, CityCode, Days from Flight order by CodeFlightId", con);

Please check this Query, I need Alphabet wise.

Please help, Please correct this Query

StianSandberg 17-Jul-12 6:37am

your query "SELECT ClearanceNumber, CodeFlightId, DateLastChange, DateValidFrom,DateValidTo, ReservationNo, AircraftType, CityCode, Days
FROM Flight
ORDER BY CodeFlightId"
will return all data ordered by CodeFlightId ascending. Are you downwoting two perfectly correct answers here?

Ranjith Reddy CSE 17-Jul-12 6:28am

This Query am using in dropdown list.....when i select sort by codeflightid it must display alphabet wise.

Please help , above is my query, am using that query in dropdownlist.