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
- 7655 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 resultset concur_updatable?
What is Dependency Injection and provide example?
What is msdb database? : SQL Server Architecture
Can multiple columns be used in sql group by clause in ms sql server?
How do clustered indexes store data?
Are all views updatable ?
Describe in brief sql server monitoring ways.
What is the log shipping?
What are the different type of replication in sql server?
What are two difference between sql azure and azure tables?
What is RMS migrations?
What are the advantages of paper records?
What are Spatial data types in SQL Server 2008
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
