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
- 8214 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 the use of sql profiler in sql server 2012?
What are data files?
what is bit datatype? : Sql server database administration
Explain the difference between HTTP and HTTPS in database?
What is xdr?
Explain what is meant by replication of database?
How to convert a numeric expression from one data type to another?
what are isolation levels? : Sql server database administration
What is thr feature of change data capture?
What is intellisense?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
How we can compare two database data?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
How sql server executes a statement with nested subqueries?
Is sql server implemented as a service or an application? : Sql server database administration
