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
- 8195 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is meant by referential integrity?
Is candidate a key?
Define cursor locking
What does sql server mean?
What is transaction server distributed transaction?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What is application role in sql server database security? : sql server security
How to write a query with a left outer join in ms sql server?
What language is sql server written in?
How to enter binary string literals in ms sql server?
Explain the properties of subqueries in sql server?
What stored by the model? : sql server database administration
Can sql server 2016 run on windows 7?
What are the different types of locks in the database?
What is conditional split?
