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
- 7650 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
how will add additional conditions in sql?
What are the pre-defined functions in the sql server?
What is sql server 2000 work load governor?
What is a database table?
What are various limitations of the views?
What are subqueries in sql server?
How do you set a trace flag in sql server?
Why main is user defined function?
What is the difference between mysql and sql server?
Explain the third normal form(3nf)?
How can I get data from a database on another server?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What is difference between rownum and row_number?
What happens to a statement batch if there is a compilation error?
What are the export options of ssrs?
