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
- 7659 Views
- I also Faced
- E-Mail Answers
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 indexed view? How to create it?
Define ACID properties in a Database?
What is temporary stored procedure?
What is the difference between migration and upgradation in sql server?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
Describe in brief databases and sql server databases architecture.
How to perform backup for certificates in sql server? : sql server security
What is side by side migration in sql server?
how would you improve etl (extract, transform, load) throughput?
Scalability, Availability, Integration with internet, etc.)?
How to write an inner join with the where clause in ms sql server?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What the different components in replication and what is their use?
What stored procedure can you use to display the current processes?
What is the difference between grant and with grant while giving permissions to the user?
