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

What are the basic features of a trigger in ms sql server?

1109

What do you mean by sql server 2005 express management tools?

1250

How to use copy and concatenate commands in SQL?

1063

How to connect of datebase with sql express.?

1049

what are defaults? : Sql server database administration

1004

How much space does sql server 2016 take?

908

How do I clean up sql server transaction log?

993

How sql server executes a statement with nested subqueries?

958

What is collation sensitivity?

985

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

891

How to retrieve error messages using odbc_errormsg()?

990

What is self join in sql server joins?

961

What are differences in between sql server 2012 and sql server 2016?

978

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1087

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1264