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
- 8198 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
What is the Main Difference between ACCESS and SQL SERVER?
What are sql azure firewall rules?
Explain boyce and codd normal form(bcnf)?
What is 'Join' and explain its various types.
Why are sql functions used?
Can we use where clause with group by?
How would you go about developing a ssrs report?
how many clustered indexes can be created on a table? : Sql server database administration
Does union all remove duplicates?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
How to trouble shoot if unable to connect SQL Server
How many clustered indexes there can be on table ?
What is difference between index and primary key?
What is xdr?
Explain what is the main purpose of having conversation group?
