Recent posts under tag sql

+1 vote

1 answer

What is anonymous block using cursor?

posted Jun 25, 2015 by Priyadharshini Kunjithapatham

+1 vote

1 answer

How can one rename a column in a table in Oracle 8i?

posted Jun 24, 2015 by Archana

+2 votes

1 answer

How can one drop a column from a table in Oracle 8i?

posted Jun 24, 2015 by Archana

+2 votes

1 answer

please explain the Properties of adhoc query?

posted Jun 23, 2015 by Mohammed Hussain

+4 votes

2 answers

How sql server know when a query has to compile or not?

posted Jun 23, 2015 by Mohammed Hussain

+3 votes

0 answers

What is Adhoc query in sql server: cached Query Plan?Please explain with example?

posted Jun 23, 2015 by Mohammed Hussain

0 votes

1 answer

How can one dump/ examine the exact content of a database column?

posted Jun 23, 2015 by Vidhya Sagar

+2 votes

1 answer

How does one implement IF-THEN-ELSE in a select statement?

posted Jun 23, 2015 by Vidhya Sagar

+2 votes

1 answer

SQL Server Transactions and Error Handling

posted Jun 23, 2015 by Manikandan J

+4 votes

1 answer

When should we use EXISTS, and when should we use IN?

posted Jun 23, 2015 by Manikandan J

+2 votes

1 answer

What is the difference between SQL, PL-SQL and T-SQL?

posted Jun 23, 2015 by Manikandan J

+1 vote

1 answer

How to create Nested SQL Cursors in sql server?

posted Jun 23, 2015 by Shivaranjini

+1 vote

1 answer

How to create Cursor inside cursor in sql server?

posted Jun 23, 2015 by Shivaranjini

0 votes

1 answer

oracle: How does one code a matrix report in SQL?

posted Jun 22, 2015 by Suchithra

0 votes

1 answer

Oracle: How does one code a tree-structured query?

posted Jun 22, 2015 by Suchithra

+1 vote

1 answer

Oracle: How does one count/sum RANGES of data values in a column?

posted Jun 19, 2015 by Kunal Kapoor

+2 votes

1 answer

How does one count different data values in a column In Oracle?

posted Jun 19, 2015 by Kunal Kapoor

+2 votes

1 answer

Update from one table to another table using SQL Server 2008

posted Jun 19, 2015 by Shivaranjini

+2 votes

1 answer

how to update table from select statement in sql server?

posted Jun 19, 2015 by Shivaranjini

+3 votes

1 answer

SQL update from one Table to another based on a ID match

posted Jun 19, 2015 by Manikandan J

+3 votes

1 answer

SQL Server - Update column from data in the same table

posted Jun 19, 2015 by Manikandan J

+3 votes

1 answer

Any body know the query about this senario

posted Jun 18, 2015 by Shivaranjini

+4 votes

1 answer

Please let me know the query to update this

posted Jun 18, 2015 by Shivaranjini

+1 vote

1 answer

Oracle: How does one add a day/hour/minute/second to a date value?

posted Jun 17, 2015 by Archana

0 votes

1 answer

Oracle: How can I get the time difference between two date columns?

posted Jun 17, 2015 by Archana

0 votes

1 answer

Oracle: How can I generate primary key values for my table?

posted Jun 17, 2015 by Vidhya Sagar

0 votes

1 answer

Oracle: How does one eliminate duplicates rows from a table with different methods?

posted Jun 17, 2015 by Vidhya Sagar

+2 votes

2 answers

Deleting duplicate rows from a table.

posted Jun 16, 2015 by Manikandan J

+2 votes

1 answer

Finding TOP X records from each group.

posted Jun 16, 2015 by Manikandan J

+1 vote

1 answer

SQL: Need help with Multiple Joins of Tables?

posted Jun 16, 2015 by Shivaranjini

+1 vote

1 answer

Help with Join operation in SQL

posted Jun 16, 2015 by Shivaranjini

+1 vote

1 answer

SQL: Get the highest number of each group and combine the result per parent column?

posted Jun 16, 2015 by Shivaranjini

+2 votes

1 answer

What is the default size of SQL Server Database

posted Jun 15, 2015 by Shivaranjini

+1 vote

1 answer

How to create a UNIQUE Key on a Column which is having multiple NULL values?

posted Jun 15, 2015 by Shivaranjini

+1 vote

1 answer

A table named fruit has the attributes "ID", "Fruit name" and "Basket No":

posted Jun 15, 2015 by Shivaranjini

+1 vote

1 answer

How to escape special characters when building SQL queries?

posted Jun 15, 2015 by Suchithra

+1 vote

2 answers

What is SQL and where does it come from?

posted Jun 15, 2015 by Suchithra

0 votes

1 answer

Oracle: How display the names of employees who are working in the company for the past 5 years?

posted Jun 12, 2015 by Kunal Kapoor

+1 vote

1 answer

sql query of EMP table?

posted Jun 12, 2015 by Kunal Kapoor

+3 votes

1 answer

How to display the names of employees in Sql Query?

posted Jun 11, 2015 by Archana

+2 votes

1 answer

How to display names of employees who do not earn any commission in Oracle?

posted Jun 11, 2015 by Viswas Kumar

+2 votes

1 answer

How to display employee number and names for employees who earn commission in Oracle?

posted Jun 11, 2015 by Viswas Kumar

+2 votes

1 answer

How to display the names of all employees working as clerks and drawing a salary more than 3000?

posted Jun 9, 2015 by Vidhya Sagar

0 votes

2 answers

How to display the names of all employees who are working in department number 10 in Oracle?

posted Jun 9, 2015 by Vidhya Sagar

+1 vote

1 answer

How to display employee name and annual salary for all employees?

posted Jun 9, 2015 by Suchithra

+1 vote

1 answer

Display employee number and total salary for each employee in Oracle?

posted Jun 9, 2015 by Suchithra

+1 vote

1 answer

How to display name and salary for all employees?

posted Jun 5, 2015 by Kunal Kapoor

+1 vote

1 answer

How to display the name and job for all employees?

posted Jun 5, 2015 by Kunal Kapoor

+1 vote

1 answer

How to display the details of all employees in Oracle?

posted Jun 3, 2015 by Archana

+1 vote

1 answer

How to display the dept information from department table in Oracle?

posted Jun 3, 2015 by Archana