-
How to get number of days using SQL ?
I have table .. like EMPNO Ename DOB ------------------------------------ 1 you 1-jan-2011 2 Me 28-jan-2011 tel me the query for no.of days different from.. two dates of column DOB.? Thanks in advance. Sateesh
-
How to get the First name,second name,Third name ?
I have a column in a table with names.Now i want to select that names like first name,second and third.I/p like this----- names Chandu Kannaka prasad Rama krishna Kiran kumar Kora Balaji Chandra sekhar pottaO/p I want------ Firstname Secondname Thirdname ...
-
How to change the column name by using ALTER?
I Tried by giving......................... ALTER table table name rename column tocolumn name was changed but it's not giving entire table with altered column name.It's giving only the altered column.
-
-