how to set row value at last of table even after inserting values

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

SQL

create table callRecords
(
srNo int identity(1,1),
mode varchar(20)
)
<pre lang="sql">
insert into callRecords values ('Email')
insert into callRecords values ('Telephone')
insert into callRecords values ('Others')
insert into callRecords values ('fax')
insert into callRecords values ('paper')

select * from callRecords
</pre>

output of above query is
srNo mode
1 Email
2 Telephone
3 Others
4 fax
5 paper

but i want that 'others' value at last of table even after further inserting values
srNo mode
1 Email
2 Telephone
3 fax
4 paper
5 Others

is there any way to do this ???

Posted 26-Aug-15 20:41pm

Member 11844168

Add a Solution

Comments

Arasappan 27-Aug-15 2:58am

I thing u do this for dropdownlist ..Right..?

Member 11844168 27-Aug-15 3:11am

yes right :-)

Arasappan 27-Aug-15 3:43am

can i Give the solution..for dropdownlist not in sql...

Arasappan 27-Aug-15 3:45am

If ur answer yes mean..show ur code to bind the data in C#..

Arasappan 27-Aug-15 3:49am

or in sql..If u can put the other at first

Member 11844168 27-Aug-15 4:44am

sql query i am looking for

1 solution

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)

Maciej Los · Answer 1 · 2015-08-26T21:20:00

Solution 1

If i understand you well, you want to sort data. One of possible way is to use ORDER BY[^] clause.

SQL

SELECT *
FROM callRecords
ORDER BY CASE WHEN SrNo=3 THEN 1 ELSE 0 END, SrNo

Posted 26-Aug-15 21:20pm

Maciej Los

Comments

Member 11844168 27-Aug-15 3:25am

no

Maciej Los 27-Aug-15 3:27am

No - what? Please, be more specific and provide more details.

Member 11844168 27-Aug-15 3:28am

any of the further insertions ..the 'other' value should be at last row

Maciej Los 27-Aug-15 3:32am

Impossible! because SrNo is identity column, which means that this field is automatically increased. To be able to achive such kind functionality you'll need to delete 'Other' value, then to insert new data and finally to insert 'Other' value again. Get it?

Member 11844168 27-Aug-15 3:29am

like in dropdownlist...we have other value at last

Arasappan 27-Aug-15 3:48am

or in sql..If u can put the other at first