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
- 8 Answers
- 5946 Views
- I also Faced
- E-Mail Answers
Answer Posted / archana
Select * from #emp Order by id,Groupname
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the default server name for sql server?
What are the advantages of stored procedure in sql server?
what is bit datatype? : Sql server database administration
What is merge join?
Is sql server free?
Can another user execute your local temporary stored procedures?
How optimize sql query with multiple joins in sql server?
What are ddl triggers and types of ddl trigger?
Explain about builtinadministrator?
How can we get count of the number of records in a table?
What are the advantages of sql azure?
What is trace flag in sql server?
What is named query? : sql server analysis services, ssas
Explain full-text indexing?
Explain active/passive and active/active cluster configurations?
