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
- 7998 Views
- I also Faced
- E-Mail Answers
Answer Posted / getaway
Very vague question!
The asker did not give an explanation of the desired sorting rule. Without that the closest answer is to sort based on Order by groupname, name
Of course specifying the query's output through CASE..WHEN.. is the "smartest" idea. If you give me this answer at the job interview, I positively won't hire you. As it was mentioned in answer #4, what if the table has 1000 rows? And in a week - 5000? How you gonna manage your query?
Good luck.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain transaction server isolation?
What is difference between after and before?
What is a non-clustered index?
What is local temp table?
What is store procedure? How do they work? When do you use?
What is cursor in ms sql server?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is the server name in sql server?
Who developed sql server?
You want to use a perspective in an mdx query. How do you select the perspective?
What is the difference between ddl,dml and dcl commands?
What is cdc in sql server?
Explain subquery and state its properties?
Explain about analysis services?
What are Row versions of DataRow?
