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
- 8013 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
SELECT ROW_NUMBER() OVER(ORDER BY GROUPNAME ASC) ID
,NAME,GROUPNAME FROM REC ORDER BY GROUPNAME
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / pradip jain
Hi Ram, what new you are done man?
you have posted same answer as me.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / praveen kumar
this is not right query beacuse if table contain 1000
record then you need to give 1000 condition .so it is not
right answer
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / alka
select id,name, groupname from #temp1
Order by groupname,name
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / ram birendra jha
SELECT
case name
When 'R4' then 1
When 'R5' then 2
When 'R6' then 3
When 'R7' then 4
When 'R11' then 5
When 'R1' then 6
When 'R3'then 7
When 'R2'then 8
When 'R8' then 9
When 'R9' then 10
When 'R10' then 11
END as Id,
name,groupname FROM Tempid
ORDER BY Id
| Is This Answer Correct ? | 0 Yes | 1 No |
What are date and time data types in ms sql server?
How to verify a login name with sqlcmd tool?
Can two tables share a primary key?
What stored by the master?
How can your resolve deadlocks?
4 Answers IBM, IMS, Iron Mountain, NuWare,
How to create a trigger for insert only?
How do I manually uninstall an instance of sql server 2016?
Are null values the same as that of zero or a blank space?
Explain what is “asynchronous” communication in sql server service broker?
How many databases instances are there in sql server 2000?
Describe in brief sql server monitoring ways.
How can sql server instances be hidden? : sql server security
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
