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
Answer Posted / alka
select id,name, groupname from #temp1
Order by groupname,name
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is nonclustered index on computed columns?
What are the advantages of paper records?
Explain the different types of joins?
what is unique and xaml nonclustered index
What is meant by referential integrity?
What is the concept of optimization?
Explain differentiate between a having clause and a where clause?
How do I find the port number for sql server?
What types of replication are supported in sql server?
how to do partition in sqlserver
Explain timestamp datatype?
Explain what is the main purpose of having conversation group?
How many types of built in functions are there in sql server 2012?
What is database white box testing?
What are the advantages of stored procedure in sql server?