SQL/MySQL/ORACLE DBA Learning

send me personaly i have not copy

I have a table students. It has a column students_id other than id. It is in natural order (1-5) i just want to changes its values with odd numbers only. For example: Student_id= 1,2,3,4,5 To Student_id= 1,3,5,7,9

GN

In Mysql update Students as s Set students_id = (Select 2*(s.rowid-1)+1 from Students) Where students_id=s.rowid;

Hii, I am new one here can Any tell me how optimization of Sql server CPU usage in Microsoft

While running query optimize table does it need to downtime

Hi

How to fetch 2nd highest salary with co orelated method.

Hi

Wo

I Learn Oracle DBA ? Please tell me any institute around navi mumbai

PYTHON LIFE