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
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 |
how do u do Performance tunning ?
1 Answers Infodat Technologies, Satyam,
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
How to create an index on a view?
How many categories of data types used by sql server?
Is sql server is free?
How to list all user defined functions in the current database?
Explain what is scheduled job and how to create it?
How to find the service pack installed? : sql server database administration
Can you explain different types of locks in sql server?
Can sql server be linked with other servers like oracle?
What is row_number()?
ow to bring suspect mode datbase online from scratch