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
9025 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 is plan freezing?

964

Mention the differences between substr and charindex in sql server.

1043

State the difference between local and global temporary tables?

1115

What is an index. What are the types?

1085

what method you can use to reduce the overhead of Reporting Services data sources?

253

How does index makes search faster?

970

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1028

how will add additional conditions in sql?

1093

What is the size of transaction log file?

925

What is function of ROLLUP ?

1080

How many types of objects are there?

1002

What is the purpose of sql profiler in sql server? : sql server database administration

1103

What is failover clustering overview?

1083

What are the different ways you can create databases in sql server?

1100

What is coalesce in sql server?

1049