- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
6 Posted Topics
Try This code: <html> <head> <style> .float{z-index:10;} .float,.header{ width: 100%; height: 100%; position: absolute; top: 0; left: 0; } </style> </head> <body> <div class="header">First Div <div class="float"> Second Div </div> </div> </body> </html>
Replace CASE block with this! Update [TableName] set c.user_one=case when c.user_two=99 then u.uid else c.user_one end , c.user_two=case when c.user_one=99 then u.uid else c.user_two end
Try this one it works! UPDATE dembel SET userid=8909 WHERE Name='o''reily'
By this Query , required data is fetched!! UPDATE temp SET time2=NOW() WHERE time1 in (SELECT max(time1) FROM temp WHERE user='kraso')
Try this query!!It works! SELECT col1, MAX(col2) AS [col2] FROM ( SELECT col1,col2 FROM Table1 UNION SELECT col1, col2 FROM Table2 ) u GROUP BY col1 ORDER BY col1
The End.
Sherin Mathew