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
- 8019 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
Is INSTEAD OF trigger directly applicable to Table ?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
What are the difference between clustered and a non-clustered index?
Where sql server user names and passwords are stored in sql server? : sql server database administration
Explain tablesample?
What is the difference between value type and reference type?
Is BCNF better than 2NF & 3NF? Why?
How to create new databases with "create database" statements?
How to link tables in sql server?
How do I install sql server?
What is microsoft sql server?
How to connect ms access to sql servers through odbc?
How to set database to be read_only in ms sql server?
Do you know what guidelines should be followed to help minimize deadlocks?
What are the key configuration files for sql server reporting services ?
