tag:blogger.com,1999:blog-37947044041595745322024-03-14T03:00:44.690-07:00Sql Queries in Oracle and SQL ServerSQLQueriesCollection is blog for all sql queries in SqlServer at one place.SQL,SQL Query,SQL Queries,SQL Query Code,SQL Query Example,SQL Query Syntax,Basic Sql Queries,Query,SQL Examples,SQL Basic Queries,Structured Query Language,sql oracle queries,oracle sql queries,sql queries in oracle,sql-oracle,oracle sql.oracle basics,sql basics,oracle sql examples,sql orqcle examplessqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.comBlogger39125tag:blogger.com,1999:blog-3794704404159574532.post-62785162372344812032013-02-07T00:11:00.003-08:002013-02-07T00:11:44.764-08:00Sql Queries:How to convert number into words in oracle using sql query<div dir="ltr" style="text-align: left;" trbidi="on">
How to convert number into words in oracle using sql query<br />
<br />
<br />
select to_char(to_date(4321,'J'), 'JSP') as word from dual;<br />
<br />
<br />Output-FOUR THOUSAND THREE HUNDRED TWENTY-ONE<br />
<br />
<br />select to_char(to_date(123,'J'), 'JSP') as word from dual;<br />
<br />
<br />Output-ONE HUNDRED TWENTY-THREE<br />
<br />
<br />Above query works only for numbers from 1 to 5373484.<br />
<br />
<br />
select to_char(to_date(5373485,'J'), 'JSP') as word from dual;<br />
<br />Output-We get error as "julian date must be between 1 and 5373484"</div>
sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-78473672300894877532012-11-18T00:00:00.000-08:002012-11-18T00:00:00.418-08:00sql query to drop column<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
sql query to drop column<br />
<br />
<br />
alter table tablename drop column columnname;</div>
sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-37711891801433803062012-11-17T06:19:00.000-08:002012-11-17T06:19:00.741-08:00sql query to rename table name in oracle/rename oracle table<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
sql query to rename table name in oracle/rename oracle table<br />
<br />
<br />
alter table oldtablename rename to newtablename</div>
sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-61133794229082148572012-11-16T03:00:00.000-08:002012-11-16T03:00:15.149-08:00sql query to add new column to table in oracle<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
sql query to add new column to table in oracle<br />
<br />
<br />
alter table tablename add (columname columndatatype)<br />
</div>
sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-61031177234671643272012-11-16T02:00:00.000-08:002012-11-16T02:00:13.376-08:00sql query to rename column in oracle/renaming column in oracle<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
sql query to rename column in oracle<br />
<br />
<br />
<br />
alter table tablename rename column oldcolumn to newcolumn<br />
</div>
sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-61862621816404605742012-11-15T06:13:00.002-08:002012-11-15T06:13:30.491-08:00sql query to convert date to mm/dd/yyyy hh:mi:ss including AM/PM<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
sql query to convert date to mm/dd/yyyy hh:mi:ss including AM/PM.<br />
<br />
<br />
<br />
SELECT to_char(sysdate,'mm/dd/yyyy hh:mi:ss PM')Alias from dual;<br />
<br />
<br />
output-<br />
<br />
11/14/2012 07:56:46 AM</div>
sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-60011118736673916862012-11-15T00:30:00.001-08:002012-11-15T06:15:50.933-08:00sql query to get 5th record in oracle-how to get 5th record of table in oracle<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
sql query to get 5th record in oracle<br />
<br />
<br />
<br />
SELECT * FROM tablename WHERE rownum <= 5 MINUS SELECT * FROM tablename where rownum < 5;<br />
<br />
</div>
sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-11639911760819540252012-11-15T00:30:00.000-08:002012-11-15T00:30:00.913-08:00sql query to convert date to mm/dd/yyyy hh:mi:ss format -oracle sql queries-to_char function<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
sql query to convert date to mm/dd/yyyy hh:mi:ss format<br />
<br />
<br />
<br />
<br />
SELECT to_char(sysdate,'mm/dd/yyyy hh:mi:ss')Alias from dual;<br />
<br />
<br />
output-<br />
<br />
<br />
11/14/2012 07:56:29</div>
sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-24683675008152706852012-11-14T06:27:00.001-08:002012-11-14T06:27:29.252-08:00sql query to get system date in oracle<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
sql query to get system date in oracle<br />
<br />
<br />
select sysdate from dual<br />
<br />
<br />
output-<br />
<br />
14-NOV-12</div>
sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-88927309262709028302009-06-26T05:52:00.000-07:002009-06-26T06:38:53.315-07:00SQL Query To Drop a Table in SQL Server<a href="http://funandknowledge.blogspot.com/2007/12/sql-server-faqs.html">Sql Server Faqs</a><br /><a href="http://sqlqueriescollection.blogspot.com/2009/04/sql-query-to-return-information-about.html">Check this post for SQL Query to Return Information About all Databases in SQL Server</a><br /><br />SQL Query To Drop a Table in SQL Server.<br /><br />syntax:Drop Table Tablename<br /><br />ex:DROP TABLE Emp<br /><br />Above Query Drops Emp table in the current database.<br /><br /><a href="http://moviessongslyrics.blogspot.com" target="_blank">Movie Songs Lyrics</a><br /><a href="http://funandknowledge.blogspot.com" target="_blank">Software Testing-QTP Scripts,Testing Faqs</a>sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-45356765000057474972009-05-06T07:47:00.000-07:002009-05-06T07:56:36.845-07:00SQL Query to Return Information about a single database<a href="http://funandknowledge.blogspot.com/2007/12/sql-server-faqs.html">Sql Server Faqs</a><br /><br /><a href="http://sqlqueriescollection.blogspot.com/2009/04/sql-query-to-return-information-about.html">Check this post for SQL Query to Return Information About all Databases in SQL Server</a><br /><br />SQL Query to Return Information about a single database<br /><br /><br />Syntax:exec sp_helpdb databasename<br /><br /><br />ex:exec sp_helpdb lakshmisqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-44114565754027787762009-04-23T07:50:00.000-07:002009-04-23T07:59:06.822-07:00SQL Query to Return Information About all Databases in SQLServer<a href="http://funandknowledge.blogspot.com/2007/12/sql-server-faqs.html">Check this post for sqlserver faqs</a><br /><br /><br />SQL Query to Return Information About all Databases in SQL Server<br /><br /><br />exec sp_helpdb<br /><br /><br /><a href="http://sqlqueriescollection.blogspot.com/2009/04/sql-query-to-delete-multiple-databases.html">Check here for SQL Query to delete multiple databases in sqlserver</a><br /><a href="http://sqlqueriescollection.blogspot.com/2009/04/sql-query-to-rename-database-in-sql.html">SQL Query to rename database in sqlserver.</a><br /><a href="http://moviessongslyrics.blogspot.com" target="_blank">Movie Songs Lyrics</a><br /><a href="http://funandknowledge.blogspot.com" target="_blank">Software Testing-QTP Scripts,Testing Faqs</a>sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-78958322523908375892009-04-13T06:16:00.000-07:002009-04-13T22:53:09.058-07:00SQL Query to Delete Multiple Databases in SQL Server-SQL Queries<a href="http://sqlqueriescollection.blogspot.com/2009/04/sql-query-to-delete-database-in-sql.html">Check This Post for sql query to delete single database in sql server</a><br /><br />SQL Query to drop multiple databases in sqlserver.<br /><br /><br />Syntax:DROP DATABASE databasename1, databasename2<br /><br />Example:Drop Database Lakshmi1,Lakshmi2<br /><br /><a href="http://sqlqueriescollection.blogspot.com/2009/04/sql-query-to-rename-database-in-sql.html">Check This SQL Query to Rename Database</a><br /><a href="http://sqlqueriescollection.blogspot.com/2009/02/sql-query-to-find-minimum-salary-from.html">Check this post for SQL Query To Find Minimum Salary From Emp Table in SQLSERVER.</a><br /><a href="http://sqlqueriescollection.blogspot.com/2009/02/sql-query-to-find-maximum-salary-from.html">Sql query to find highest salary in sqlserver.</a><br /><a href="http://sqlqueriescollection.blogspot.com/2009/01/sql-query-to-retrieve-nth-highest.html">Check this post to get 2nd and 3rd Highest salary</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-copy-structure-of-one-table-into.html">SQL Query to copy only structure of one table to other table in SqlServer</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-get-structure-of-table-in-sql.html">SQL Query to get structure of table in SqlServer</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-get-structure-of-table-in-sql.html"></a><a href="http://moviessongslyrics.blogspot.com" target="_blank">Movie Songs Lyrics</a><br /><a href="http://funandknowledge.blogspot.com" target="_blank">Software Testing-QTP Scripts,Testing Faqs</a>sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-76600973948923894182009-04-05T21:49:00.000-07:002009-04-05T22:03:37.429-07:00SQL Query to Delete Database in Sql Server-SQL Queries in SQLServer<a href="http://funandknowledge.blogspot.com/2007/12/sql-server-faqs.html">Check this post for SqlServer Faqs</a><br /><br />SQL Query to Drop Database in Sql Server<br /><br /><br />Syntax:DROP DATABASE databasename<br /><br />Example:drop database lakshmi<br /><br /><a href="http://sqlqueriescollection.blogspot.com/2009/04/sql-query-to-rename-database-in-sql.html">Check This SQL Query to Rename Database</a><br /><br /><a href="http://sqlqueriescollection.blogspot.com/2009/02/sql-query-to-find-minimum-salary-from.html">Check this post for SQL Query To Find Minimum Salary From Emp Table in SQLSERVER.</a><br /><a href="http://sqlqueriescollection.blogspot.com/2009/02/sql-query-to-find-maximum-salary-from.html">Sql query to find highest salary in sqlserver.</a><br /><a href="http://sqlqueriescollection.blogspot.com/2009/01/sql-query-to-retrieve-nth-highest.html">Check this post to get 2nd and 3rd Highest salary</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-copy-structure-of-one-table-into.html">SQL Query to copy only structure of one table to other table in SqlServer</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-get-structure-of-table-in-sql.html">SQL Query to get structure of table in SqlServer</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-get-structure-of-table-in-sql.html"></a><a href="http://moviessongslyrics.blogspot.com" target="_blank">Movie Songs Lyrics</a><br /><a href="http://funandknowledge.blogspot.com" target="_blank">Software Testing-QTP Scripts,Testing Faqs</a>sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-79354464694966488462009-04-01T23:45:00.000-07:002009-04-02T00:07:34.516-07:00SQL Query to Rename Database in SQL ServerSQL Query to rename database.<br /><br />Syntax: sp_renamedb 'olddatabasename','newdatabasename'<br /><br />Example: sp_renamedb 'Lakshmi','Laxmi'<br /><br /><a href="http://sqlqueriescollection.blogspot.com/2009/02/sql-query-to-find-minimum-salary-from.html">Check this post for SQL Query To Find Minimum Salary From Emp Table in SQLSERVER.</a><br /><a href="http://sqlqueriescollection.blogspot.com/2009/02/sql-query-to-find-maximum-salary-from.html">Sql query to find highest salary in sqlserver.</a><br /><a href="http://sqlqueriescollection.blogspot.com/2009/01/sql-query-to-retrieve-nth-highest.html">Check this post to get 2nd and 3rd Highest salary</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-copy-structure-of-one-table-into.html">SQL Query to copy only structure of one table to other table in SqlServer</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-get-structure-of-table-in-sql.html">SQL Query to get structure of table in SqlServer</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-get-structure-of-table-in-sql.html"></a><a href="http://moviessongslyrics.blogspot.com" target="_blank">Movie Songs Lyrics</a><br /><a href="http://funandknowledge.blogspot.com" target="_blank">Software Testing-QTP Scripts,Testing Faqs</a>sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-17236677128543486162009-02-16T11:05:00.000-08:002009-02-16T11:15:10.457-08:00SQL Query To Find Minimum Salary From Emp Table in SQLSERVER.sql query to get min sal from emp table<br /><br /><a href="http://sqlqueriescollection.blogspot.com/2009/01/sql-query-to-retrieve-nth-highest.html">Check this post to find 2nd and 3rd Highest salary</a><br /><br />sql query to get least salary from emp table<br /><br /><br />Syntax:select min(columnname)as MIN_SAL from tablename<br /><br /><br />Ex:select min(sal)as MIN_SAL from emp<br /><br /><a href="http://sqlqueriescollection.blogspot.com/2009/02/sql-query-to-find-maximum-salary-from.html">Sql query to find highest salary in sqlserver.</a><br /><a href="http://sqlqueriescollection.blogspot.com/2009/01/sql-query-to-retrieve-nth-highest.html">Check this post to get 2nd and 3rd Highest salary</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-copy-structure-of-one-table-into.html">SQL Query to copy only structure of one table to other table in SqlServer</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-get-structure-of-table-in-sql.html">SQL Query to get structure of table in SqlServer</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-get-structure-of-table-in-sql.html"></a><a href="http://moviessongslyrics.blogspot.com" target="_blank">Movie Songs Lyrics</a><br /><a href="http://funandknowledge.blogspot.com" target="_blank">Software Testing-QTP Scripts,Testing Faqs</a>sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-48427593671831611632009-02-05T02:39:00.000-08:002009-02-05T02:56:26.669-08:00SQL Query To Find Maximum Salary From Emp Table in SQLSERVER.<a href="http://sqlqueriescollection.blogspot.com/2009/01/sql-query-to-retrieve-nth-highest.html">Check here to find 2nd and 3rd Highest salary</a><br /><br />sql query to get first highest salary from emp table<br /><br /><br />Syntax:select max(columnname)as MAX_SAL from tablename<br /><br /><br />Ex:select max(sal)as MAX_SAL from emp<br /><br /><br /><a href="http://sqlqueriescollection.blogspot.com/2009/01/sql-query-to-retrieve-nth-highest.html">Check this post to get 2nd and 3rd Highest salary</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-copy-structure-of-one-table-into.html">SQL Query to copy only structure of one table to other table in SqlServer</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-get-structure-of-table-in-sql.html">SQL Query to get structure of table in SqlServer</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-get-structure-of-table-in-sql.html"></a><a href="http://moviessongslyrics.blogspot.com" target="_blank">Movie Songs Lyrics</a><br /><a href="http://funandknowledge.blogspot.com" target="_blank">Software Testing-QTP Scripts,Testing Faqs</a>sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-56764390771983362892009-01-30T02:39:00.000-08:002009-01-30T03:01:41.249-08:00Sql Query to Retrieve Nth Highest Salary From Table in SQL Server<a href="http://funandknowledge.blogspot.com/2007/12/sql-server-faqs.html">SQL Server Faqs</a><br /><br />SQL Query to find Nth Highest Salary in SQL Server.<br /><br />SELECT * FROM tablename e1 WHERE N = (SELECT COUNT(DISTINCT (e2.sal))<br />FROM tablename e2 WHERE e2.sal >= e1.sal)<br /><br />For example to get 3rd highest salary:<br />SELECT * FROM emp e1 WHERE 3 = (SELECT COUNT(DISTINCT (e2.sal))FROM emp e2 WHERE e2.sal >= e1.sal)<br /><br />Similarly to get 2nd highest salary:<br />SELECT * FROM emp e1 WHERE 2 = (SELECT COUNT(DISTINCT (e2.sal))FROM emp e2 WHERE e2.sal >= e1.sal)<br /><br /><a href="http://funandknowledge.blogspot.com/2007/12/sql-server-faqs.html">SQL Server Faqs</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-copy-structure-of-one-table-into.html">SQL Query to copy only structure of one table to other table in SqlServer</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-get-structure-of-table-in-sql.html">SQL Query to get structure of table in SqlServer</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-get-structure-of-table-in-sql.html"></a><br /><a href="http://moviessongslyrics.blogspot.com" target="_blank">Movie Songs Lyrics</a><br /><a href="http://funandknowledge.blogspot.com" target="_blank">Software Testing-QTP Scripts,Testing Faqs</a>sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com1tag:blogger.com,1999:blog-3794704404159574532.post-21966812130609396782009-01-06T07:20:00.000-08:002009-01-06T07:31:11.757-08:00How to Retrieve a Random Record from a Table in SqlServerSQL Query to display a random record from table in sqlserver.<br /><br />Syntax:Select Top 1 * From tablename Order By NewId()<br /><br />Example:Select Top 1 * From emp Order By NewId()<br /><br />Above query will display one random record.<br /><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/sql-query-to-copy-structure-and-data-of.html">SQL Query to copy structure and data of one table to other in Sql Server.</a><br /><br /><a href="http://funandknowledge.blogspot.com/">Software Testing-QTP,Testing Tools,Testing Faqs</a><br /><br /><a href="http://www.sqlqueriescollection.blogspot.com/">Collection of SQL Queries</a>sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-16932953731856029352008-12-29T20:47:00.000-08:002009-01-30T03:00:04.562-08:00SQL Query to Copy Structure and Data of One table To Other in SQLServerHow to copy structure and data of one table into another table?<br /><br />Syntax: Select * into Newtable from Oldtable<br /><br />Ex: select * into emp1 from emp<br /><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-copy-structure-of-one-table-into.html">SQL Query to copy only structure of one table to other table in SqlServer</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-get-structure-of-table-in-sql.html">SQL Query to get structure of table in SqlServer</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-get-structure-of-table-in-sql.html"></a><br /><a href="http://moviessongslyrics.blogspot.com" target="_blank">Movie Songs Lyrics</a><br /><a href="http://funandknowledge.blogspot.com" target="_blank">Software Testing-QTP Scripts,Testing Faqs</a>sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-72549872269846206192008-12-26T05:45:00.000-08:002008-12-26T05:59:54.999-08:00How to Copy Structure of One Table into Another Table?SQL Query to copy structure of one table to another table in SQL Server.<br /><br />Syntax: Select * into Newtable from Oldtable where 1=2<br /><br />Ex: Select * into emp1 from emp where 1=2<br /><br />The above query copies only structure(not data) of emp to emp1.<br /><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-get-structure-of-table-in-sql.html">SQL Query to get structure of table</a>sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com4tag:blogger.com,1999:blog-3794704404159574532.post-37910318321394843822008-12-23T02:38:00.000-08:002008-12-23T02:50:54.788-08:00How To Get Structure of a Table in SQL Server?SQL Query to view structure of a table in sqlserver.<br /><br />SP_help tablename<br /><br />SP_help empsqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-20171632189905525292008-12-15T03:40:00.000-08:002008-12-15T03:54:06.036-08:00SQL Query to find total number of rows in a tableQuery to get number of rows in a table.<br /><br />select count(*) from tablename<br /><br />ex:select count(*) as Count from emp<br /><br />Output<br /><br />Count<br />10<br /><br /><a href="http://funandknowledge.blogspot.com/2007/12/sql-server-faqs.html">SQL Server Faqs</a><br /><a href="http://www.moviessongslyrics.blogspot.com/">Movie Songs Lyrics</a><br /><a href="http://funandknowledge.blogspot.com/">SOftware Testing -QTP Scripts,Testing Faqs</a>sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-64876784447667671822008-11-20T11:09:00.000-08:002009-04-02T00:05:44.638-07:00SQL Query to Rename Column Name in SQL Server-Query to change Column Name in SQL SERVERQuery to change Column Name in SQL SERVER<br /><br />sp_rename 'Tablename.old fieldname', 'new field name'<br /><br />sp_rename 'xyz.aaa','bbb'sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0tag:blogger.com,1999:blog-3794704404159574532.post-44784282202816956432008-04-29T12:41:00.000-07:002009-01-30T03:04:51.615-08:00sql query for second highest salary in oracleselect *from emp a where 2=(select count (distinct(b.sal))from emp b where a.sal<=b.sal);<br /><br /><br />EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO<br /> 7788 SCOTT ANALYST 7566 19-APR-87 3000 20<br /><br /><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-copy-structure-of-one-table-into.html">SQL Query to copy only structure of one table to other table in SqlServer</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-get-structure-of-table-in-sql.html">SQL Query to get structure of table in SqlServer</a><br /><a href="http://sqlqueriescollection.blogspot.com/2008/12/how-to-get-structure-of-table-in-sql.html"></a><br /><a href="http://moviessongslyrics.blogspot.com" target="_blank">Movie Songs Lyrics</a><br /><a href="http://funandknowledge.blogspot.com" target="_blank">Software Testing-QTP Scripts,Testing Faqs</a>sqlquerieshttp://www.blogger.com/profile/01519510254510924137noreply@blogger.com0