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
- 8227 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
Create and insert into temp table in sql server?
Why we use trigger in sql server with example?
What is a performance monitor?
What is the difference between a function and a trigger?
Explain multiserver query
Can we check locks in database? If so, how can we do this lock check?
In what version of sql server were synonyms released?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
How to configure odbc dsn with different port numbers?
Explain about Joins?
How to view existing indexes on an given table using sp_help?
what is sql server? : Sql server database administration
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
State the difference between union and union all?
What is save transaction and save point?
