SQL QUERY STARTIGN KEY 10

Question

i have a 50 tables i want to find max key[PRIMARY KEY] start in a 10 in each table i wanna show that table how to do ??

Amitesh Verma · Answer

use like this create table #temp1 (sat1 int) insert into #temp1 values(1000) insert into #temp1 values(1001) insert into #temp1 values(1002) insert into #temp1 values(1003) insert into #temp1 values(1004) insert into #temp1 values(1005) insert into #temp1 values(1006) insert into #temp1 values(1007) select MAX(sat1) from #temp1 where sat1 like '10%' accept if you find your answer

Nizam Nizam · Answer

i have more than 50 tables each tables have the primary key it's incrimenting 12345678910 like that but i wanna show  wich tables have the max key starts 10 at last in the column tbl_Name.. 12345.6.7.8.9.10.11 tbl_Place 123..............................10001001 the above example both tables have the 10 value  but i wanna show the table which is last value in 10 like the tbl_place that is what i wanna show how to do it????

Amitesh Verma · Answer

kindly clarify your question?