Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7975 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 the different components in replication and what is their use?
What is user-defined function?
Does group by sort data?
What is replace and stuff function in sql server?
Do you know the cursor types?
What is microsoft sql server?
What is store procedure? When do you use?
How many servers can we create in a single subscription?
What command is used to create a database in the sql server and how?
What is merge statement?
Explain the purpose of indexes?
Explain system rowset functions?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
When cursors are useful?
Explain different forms of normalization?
