How to know the days or months or years between two employees in emp table.

jbabu

 Profile Answers by jbabu Questions by jbabu

• Dec 10th, 2007

Select hiredate,lead(hiredate,1) over(order by hiredate) next_months, round(months_between(lead(hiredate,1) over(order by hiredate),hiredate),3) months from emp;

Answer Question  Select Best Answer

How to fill Dataset from Datareader?

Venkat

 Profile Answers by Venkat Questions by Venkat

• Feb 12th, 2008

by using datasetds = new dataset()sqlDbAdapter ad = new sqlDbAdapter(sqlquery,connobject)ad.fill(ds,tablename)DataReaderdr = new sqlDataReader()sqlCommand sqlcmd = new sqlcommand(sqlqry,conObject)dr =...

Answer Question  Select Best Answer

What is SQL Tuning? How does it work? Thanks

abhi2433

 Profile Answers by abhi2433 Questions by abhi2433

• Feb 6th, 2008

SQL tuning is the process of ensuring that the SQL statements that an application will issue will run in the fastest possible time

Answer Question  Select Best Answer

What is the disadvantage of using "BETWEEN" for date feilds

saradajasti

 Profile Answers by saradajasti Questions by saradajasti

• Mar 24th, 2008

It won't work to selecting data in between months

Answer Question  Select Best Answer

Can you provide any security for SQL queries? If Yes, How?

chandu77

 Profile Answers by chandu77 Questions by chandu77

• Mar 17th, 2008

thru views,or stored procedures so that the underlying query is abstracted

Answer Question  Select Best Answer

In which manner the SQL commands access the data from database?

chandu77

 Profile Answers by chandu77 Questions by chandu77

• Mar 17th, 2008

Accessing data from a database depends on its implementation.consider the follwing statement select empname from emp where empid=100;(Oracle)1:first the server process of oracle checks wheth...

Answer Question  Select Best Answer

How many types of databases are there? What are they?

akavitha

 Profile Answers by akavitha Questions by akavitha

• Feb 28th, 2008

These days when we talk abt database we are mainly talking about 2 databases  namely : Analytical DatabaseOperational DatabaseAnalytical Database : Like OLTP( On Line Analytical Processing) are p...

Answer Question  Select Best Answer

How to print the number of columns in a particular table also the column names without using JDBC Result set meta data using pure SQL code.

nareannl

 Profile Answers by nareannl Questions by nareannl

• Oct 17th, 2008

Select count(column_name),column_name from user_tab_columns where table_name='tablename';

Answer Question  Select Best Answer

How to handle the table level locks and column level locks?

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 20th, 2008

When you are performing INSERT , DELETE , UPDATE operations on a table it implicity aquires row level locks.  If a transaction obtains a row lock for a row, the transaction also aquires a table l...

Answer Question  Select Best Answer

How to lock a particular row of a table using SQL?

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 20th, 2008

INSERT , UPDATE, DELETE operations implicity lock rows of a table that satisfies the condition.Explicitly you may lock a table using for update of as followsSELECT * FROM EMPWHERE EMPNO = 7369FOR UPDATE OF SAL NOWAITIt will lock single row of emp table having employee number 7369.

Answer Question  Select Best Answer

How to display & in Oracle SQL output

sailajabetha

 Profile Answers by sailajabetha Questions by sailajabetha

• Aug 18th, 2008

Use concatenate operator ...SQL> select 'a'||'&'||'b' from dual;'A'---a&b

Answer Question  Select Best Answer

How to date track 2 tables to a previous month, using SQL code

suman

• Mar 18th, 2016

Date Track allows you to maintain a continuous history of the record or information over a period of time. You can use date track history to view a report of every update ever made to a record. Whene...

Answer Question  Select Best Answer

How to retrieve names from table starting with a particular character as a first letter, using with substring, instring without using LIKE function.

askmahantesh

 Profile Answers by askmahantesh Questions by askmahantesh

• Nov 26th, 2008

Consider the table EMPLOYEES with the column ENAME. Try with the following queries.Select ename from employeeswhere Instr(ename,'&A') = 1group by ename;'A' --> your starting cha...

Answer Question  Select Best Answer

How to convert any kind of date that comes in any format from the user to 'yyyymmdd' in Oracle?

todeepakmalhotra

 Profile Answers by todeepakmalhotra Questions by todeepakmalhotra

• Nov 24th, 2008

To convert a date in a specified format you need to?convert it into character..select to_char(hire_date, 'yyyymmdd') date from employees;

Answer Question  Select Best Answer

How to open an excel sheet directly from the SQL prompt?

smonroy

 Profile Answers by smonroy Questions by smonroy

• Sep 26th, 2011

You need to use a DTS (Data Tranformation System) to SQL Server 2000 or a SSIS to SQL Server 2008 (SQL Server Integration Services), both provide programmable objects to help you

Answer Question  Select Best Answer

What are Pair Wise & Non-Pair Wise Columns?

Vinod Tuteja

• Jun 6th, 2013

NON PAIRWISE COMPARISON SUBQUERY: "sql SELECT employee_id, manager_id, department_id FROM employees WHERE manager_id IN (SELECT manager_id FROM employ...

Answer Question  Select Best Answer

What could be the maximum size of a database name in MSQL?

vinodsahani

 Profile Answers by vinodsahani Questions by vinodsahani

• May 18th, 2010

Max Length in MySql Database 64 Table 64 Column 64 Index 64 Stored Function or Procedure 64 Trigger 64 View 64 Event 64 Tablespace 64 Log File Group 64 Alias 255

Answer Question  Select Best Answer

Write a query to display the average, monthly salary bill for each job type within a department.

abhinav.abinav

 Profile Answers by abhinav.abinav Questions by abhinav.abinav

• Jan 13th, 2010

Select job,deptno,avg(sal) from emp group by job,deptno;

Answer Question  Select Best Answer

How to query the average salary for all the departments employing more than 3 people?

abhinav.abinav

 Profile Answers by abhinav.abinav Questions by abhinav.abinav

• Jan 13th, 2010

Select deptno,avg(sal),count(*) from emp group by deptno having count(*)>3;

Answer Question  Select Best Answer

What are the disadvantages of co-related sub query?

sure_prince

 Profile Answers by sure_prince Questions by sure_prince

• Dec 10th, 2009

-> It is another way of performing queries upon the data with a simulation of Joins.-> In This the information from the outer Select Statement Pratcipates As a Condition in the Inner Select Statement.-> Depending on the Supplied value the condition is qualified for the specific Record.

Answer Question  Select Best Answer