select * from table_name order by id;

here id col have primary key and identity
id name
1 a
2 b
3 c
4 d

delete 2nd row then o/p will be

id name
1 a
3 c
4 d

next inssert 2nd row and i want o/p will be
id name
1 a
2 e
3 c
4 d

Question Posted / karthikeyan

7 Answers
9296 Views
IBM, TCS, I also Faced
E-Mail Answers

Answer Posted / karthikeyan

select * from table_name order by id;

Is This Answer Correct ?

1 Yes

14 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you delete duplicate rows in sql server?

1008

what is normalization? Explain different levels of normalization? : Sql server database administration

1414

What are the properties of the transactions?

1172

Tell me what do you understand by a view? What does the with check option clause for a view do?

1062

What is exclusive locks?

1014

What are the tools available in market as an alternative to sql server reporting services?

138

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1129

What does the not null constraint do?

1180

Explain cdc and sql injection?

1045

How do I run sql server 2014?

1055

How do you know if sql server is running on your local system?

1102

Define indexes?

1096

What is de-normalization in sql database administration? Give examples?

1027

Explain the concepts and capabilities of sql server?

1014

What is key set driven?

1011