Most voted questions under tag sql

+3 votes

1 answer

how to insert multiple records in a single query?

posted May 15, 2015 by Muskan

+3 votes

1 answer

Oracle: You have just compiled a PL/SQL package but got errors, how would you view the errors?

posted Apr 8, 2015 by Kunal Kapoor

+3 votes

1 answer

Oracle: Explain what partitioning is and what its benefit is.

posted Apr 8, 2015 by Kunal Kapoor

+3 votes

1 answer

What is open query in sql server?

posted Apr 8, 2015 by Muskan

+3 votes

1 answer

What is the difference between Rollup ad cube?

posted Apr 3, 2015 by Santosh Kumar Panigrahi

+3 votes

1 answer

oracle: What does coalescing a tablespace do?

posted Apr 1, 2015 by Suchithra

+3 votes

1 answer

Oracle: Give two methods you could use to determine what DDL changes have been made

posted Mar 31, 2015 by Archana

+3 votes

1 answer

Oracle: How would you force a log switch?

posted Mar 31, 2015 by Archana

+3 votes

1 answer

How do I install the MySQLdb under python programming?

posted Mar 26, 2015 by Amit Kumar Pandey

+3 votes

1 answer

Oracle: how to display Odd/ Even number of records?

posted Mar 16, 2015 by Archana

+3 votes

1 answer

What is mixed mode authentication in sql server???

posted Mar 11, 2015 by Muskan

+3 votes

1 answer

how to find common columns in two tables?

posted Feb 23, 2015 by Muskan

+3 votes

0 answers

Oracle: Why is the query not fetching the records for the date I wanted?

posted Feb 13, 2015 by Archana

+3 votes

0 answers

Is there a way to make the Sql Server FullText engine to stop recognizing numbers as numbers?

posted Jan 2, 2015 by Vrije Mani Upadhyay

+3 votes

1 answer

Can we define exceptions twice in same block in PLSQL?

posted Dec 1, 2014 by Archana

+3 votes

1 answer

Explain three different rules that apply to NULLs when doing comparisons?

posted Nov 11, 2014 by Archana

+3 votes

1 answer

What special operators does Oracle provide for dealing with NULLs?

posted Nov 11, 2014 by Archana

+3 votes

1 answer

can any one explain about SQL Unions Clause in detail ?

posted Nov 5, 2014 by Archana

+3 votes

1 answer

Difference between TRUNCATE, DELETE and DROP commands?

posted Oct 27, 2014 by anonymous

+3 votes

3 answers

How many columns can table have in Oracle?

posted Oct 21, 2014 by Vidhya Sagar

+3 votes

1 answer

How do I keep a table synchronized with a query in SQL Server - ETL?

posted Oct 20, 2014 by Amit Sharma

+3 votes

1 answer

what is Physical Storage of the Data in Oracle?

posted Oct 14, 2014 by Archana

+3 votes

1 answer

What is concurrency in oracle?

posted Oct 9, 2014 by Vidhya Sagar

+3 votes

1 answer

Search Informatica for text in SQL override

posted Oct 7, 2014 by Amit Sharma

+3 votes

1 answer

How to write a query to find the weather string is Palindrome or not?

posted Sep 19, 2014 by Archana

+3 votes

1 answer

How long will a variable remain defined in Sql Plus?

posted Sep 17, 2014 by Archana

+3 votes

1 answer

How to send data into file.txt from the database using W mode Oracle PLSQL

posted Sep 15, 2014 by Suchithra

+3 votes

1 answer

what are the SQL REPORTING COMMANDS in Oracle sql

posted Sep 15, 2014 by Arun Gowda

+3 votes

1 answer

Real life example for Outer join and Inner join.

posted Jun 19, 2014 by Khusboo

+3 votes

1 answer

What is WebSQL?

posted Jun 4, 2014 by Muskan

+3 votes

1 answer

How can we restore a database when it showed as read only/suspect

posted May 24, 2014 by Neeraj Pandey

+3 votes

0 answers

How to convert c # inline queries into stored procedure written in transact sql?

posted May 8, 2014 by Khusboo

+3 votes

2 answers

What is the difference between GROUP BY and ORDER BY in Sql/MySql?

posted May 7, 2014 by Sachin Dahda

+3 votes

1 answer

What is the difference between CAST and CONVERT in sql server?

posted Apr 28, 2014 by Muskan

+3 votes

1 answer

Replication Administration sql

posted Mar 26, 2014 by Muskan

+3 votes

1 answer

Is it possible to get the SQL that would be generated, without running the mapping?

posted Mar 12, 2014 by Rohini Agarwal

+3 votes

1 answer

SQL: Where does the table variables and temporary tables exist in the memory?

posted Jan 4, 2014 by Atul Mishra

+3 votes

1 answer

What is Diff between primary index and primary key in sql server

posted Dec 4, 2013 by Anuj Mishra

+2 votes

1 answer

How to take SQLite dump ?

posted Nov 30, 2018 by anonymous

+2 votes

2 answers

What’re the differences between SQL, MySQL, SQLite and mSQL?

posted Sep 10, 2018 by anonymous

+2 votes

3 answers

What is use for SQL Injection?

posted Jun 30, 2018 by Puneet Batra

+2 votes

1 answer

How is natural join on table with itself is done, please explain with examples?

posted Jun 26, 2018 by anonymous

+2 votes

2 answers

What is the difference between the RANK() and DENSE_RANK() functions?

posted May 20, 2017 by Kushal S

+2 votes

3 answers

Can we have two primary keys in one table?

posted May 17, 2017 by Rohini Agarwal

+2 votes

0 answers

Why select * from dba_users shows total number of rows selected but for normal table it won't shows the count of rows?

posted Feb 21, 2017 by Chinmoy Padhi

+2 votes

1 answer

SQL database for android

posted Aug 16, 2016 by Akshay

+2 votes

1 answer

Is it possbile to write files with MySQL via SQL injection?

posted Apr 27, 2016 by Shivam Kumar Pandey

+2 votes

1 answer

How can I query parent to child with two child values and no other child values?

posted Mar 13, 2016 by Shivam Kumar Pandey

+2 votes

1 answer

Can someone explain how to write a SOQL query to get child custom object?

posted Mar 13, 2016 by Shivam Kumar Pandey

+2 votes

2 answers

How the function security works in Oracle Apps?

posted Nov 24, 2015 by Suchithra