select id,name, groupname from #temp1 Order by groupname,name

i have a table #temp1(id, Name groupname ) and record
like this 1 R1 S
2 R3 S
3 R2 S
4 R4 D
5 R5 D
6 R6 K
7 R7 K
8 R8 L
9 R9 L
10 R10 L
11 R11 K

and i want to display record based on user defind sorting
order e.g.
1 R4 D
2 R5 D
3 R6 K
4 R7 K
5 R11 K
6 R1 S
7 R3 S
8 R2 S
9 R8 L
10 R9 L
11 R10 L

Question Posted / alka

8 Answers
8197 Views
I also Faced
E-Mail Answers

Answer Posted / alka

select id,name, groupname from #temp1
Order by groupname,name

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are cursors and when they are useful?

1150

Explain external key management in sql server 2008

936

What do you mean by authentication modes in sql server?

1134

Delete duplicate rows without using rowid.

1586

Explain how to use linked server?

1031

What is triggers and stored procedures?

988

What is the difference between sdf and mdf?

1352

Explain how to maintain a fill factor in existing indexes?

1035

What is your recommendation for a query running very slow? : sql server database administration

1111

what is a live lock? : Sql server database administration

1017

What is store procedure?

1113

What is the difference between createstatement and preparedstatement?

999

Explain indexes disadvantages?

1141

Can we use pragma autonomous_transaction in trigger?

1014

What is outer join in sql server joins?

1184