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
- 8199 Views
- I also Faced
- E-Mail Answers
Answer Posted / pradip jain
SELECT
case name
When 'R4' then 1
When 'R5' then 2
When 'R6' then 3
When 'R7' then 4
When 'R8' then 5
When 'R9' then 6
When 'R10'then 7
When 'R11'then 8
When 'R1' then 9
When 'R2' then 10
When 'R3' then 11
END as RID,
name,groupname FROM TEMP1 T1
ORDER BY RID
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is data compression?
What does sql server mean?
What is cdc in sql server?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
Write query to return all rows sql?
What is exporting utility?
What is the boxing and unboxing concept in .net?
What are the steps you should follow to start sql server in single-user mode?
How much space does sql server 2016 take?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
Explain what is it unwise to create wide clustered index keys?
What is the use of toad or sqldbx.?
Explain stored procedure?
whats the maximum size of view state??
