abes_nitya

hello, i have a problem "how to find the number of columns in a table" .......i mean 'how many columns a table have...?thanks.

plz help me.... I want to find" top 5 sal from emp" how can we find???thanks.

Sir plz tell me "how to delete duplicate row from a table". thanks.bye.....

My question is about sql query: suppose that there is emp table which contain column name as empname,empno, sal etc.we want to find "nth maximum salary of an employee". by SQL query.byethanks

sir, iwant to know that "what is the difference between primary key , foreign key and secondary key" plz help me.thanks.bye.....

use this

ALTER TABLE tablename  RENAME COLUMN currentColumnName TO newColumnName

This will change hte name of the column without effecting contraints or type

sir ,i could not stoped ....without giving u a thanks.i want to say u a heartest thanks.because i have to implement this query to my project.thanks

Example:ALTER TABLE tablename RENAME newtablename

i don't want to change the table name... i want to change the column name of a tablebye

Before you ask a question in this forum, you should check out our SQL Tutorial.For our SQL Tutorial: W3Schools SQL TutorialFor a SQL Reference: W3Schools SQL Quick Reference

Gr8 work 'kaijim'.Keep it up.

sir i have tried a lot to know the answer of this question , that "how to change the column name of a table" plz help me thanks.