Database

azad yadav wrote:

write a query that produced single row find the max form two table

select max(twotable.fieldmatch) from 
(
select max(field1) as fieldmatch from table1
UNION
select max(field1) as fieldmatch from table2
)twotable

azad yadav wrote:

query that delete all redundant data from table in sql 2005

DECLARE  @i AS INT<br />
SET @i=0<br />
<br />
DECLARE  @j AS INT<br />
SET @j=1<br />
<br />
DECLARE @kosova AS VARCHAR(255)<br />
SET @kosova=''<br />
<br />
WHILE(@i<10)<br />
BEGIN<br />
	WHILE(@j<@i)<br />
	BEGIN<br />
		SET @kosova=@kosova+CAST(@i AS VARCHAR(10))<br />
		<br />
		SET @j=@j+1	<br />
	END<br />
	PRINT @kosova<br />
	set @kosova=''<br />
	SET @j=0<br />
	SET @i=@i+1<br />
END

   1
  222
 33333
4444444

I are troll