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
6928 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

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

557

Relational calculus is what type of language?

579

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

566

List out what other servers you can use with ssrs?

what are triggers? : Sql server database administration

505

Explain security with sql azure?

161

What do you understand by the denormalisation?

555

What is sql view?

542

What is sql server profiler?

574

Mention what are the core components of ssrs?

208

What is dbcc?

736

What do you do in data exploration

565

What is sql server programming?

554

What is format parameter in ssrs?

109

How display code or Text of Stored Procedure using Sql query in Sql Server ?

610