Q&A Discussions

AM GETTING THIS ERROR PLS CAN SOMEBODY TELL ME WHATS WRONG WITH THIS CODE

23rd Mar 2016, 5:53 PM

Mohammed Alghazzawi

insert sql

1 Vote

What is the GROUP BY clause in SQL??

22nd Mar 2016, 9:06 AM

LARSON CHIGBU

0 Votes

21st Mar 2016, 2:04 PM

Zain Imtiaz

why we use AS?

0 Votes

Is it possible to use multiple UNION and UNION ALL in single structure from different tables?

21st Mar 2016, 10:07 AM

naman gupta

sql union

0 Votes

Is there any way to undo a delete if you accidentally delete a table?

20th Mar 2016, 9:19 AM

Mayank Vaishnavi

how can u backup the data in your db to a csv using sql?

5 Votes

27 Answers

19th Mar 2016, 8:24 PM

Eli Wolfe

0 Votes

Is the order of the columns really important when using UPDATE?

19th Mar 2016, 2:35 PM

Lloyd Mwaluku

sql update

1 Vote

Is concat different from join?

14th Mar 2016, 11:51 PM

Kevin Kiambe

join sql

0 Votes

how to search for string starts with % itself for example %john , name is started with % itself

13th Mar 2016, 9:01 PM

behnam

2 Votes

Hi! Everybody. I use an sqlite in firefox with an sqlite plugin, i got a database with some tables but when i execute the SHOW TABLES or SHOW TABLE an error occurred. Somebody can help me please!!!!

13th Mar 2016, 9:15 AM

Gaurav Dwivedi

0 Votes

When I use ADD can I choose position in columns where it will be adding?

11th Mar 2016, 3:06 AM

Wal Fombrun Bouzi

0 Votes

How to sort in descending order?

10th Mar 2016, 10:27 AM

Shchokin Artem

0 Votes

Can somebody explain the use of NOT and its Syntex?

7th Mar 2016, 6:33 PM

Suraj Kumar

1 Vote

3rd Mar 2016, 7:22 AM

Dear SaFii

please explain truncate

1 Vote

28th Feb 2016, 1:46 PM

Mithun Miths

What is a cross join?

join sql

0 Votes

I know this is not a basic command but can anyone explain to me the use of command called "cast"?

28th Feb 2016, 9:25 AM

Ajay Pranav

-1 Vote

Any body explain primary key function

25th Feb 2016, 6:34 PM

Hendrik Jacobus Janse van Rensburg

Can i delete more than one records at the same time?

1 Vote

10 Answers

24th Feb 2016, 2:41 PM

Mithun Miths

delete sql

0 Votes

How to avoid null values?

23rd Feb 2016, 11:03 AM

PRAVEEN SINGH RAJPUT (PRINCE)

0 Votes

I firing query using 'concat' keyword with Oracle 11g but it's not working. can anyone help me?

21st Feb 2016, 3:01 PM

Ajay Pranav

concat sql

0 Votes

Which one is the best android apps to run SQL query ofline...? plzzz help me

19th Feb 2016, 12:50 PM

Ambar Dudhane

0 Votes

could anyone please share a query using the 'in' operator?

19th Feb 2016, 11:13 AM

Muhammad Suliman

0 Votes

Is there any major reason why we should use LİMİT when retrieving records?

16th Feb 2016, 10:18 AM

Nirab Gouda

1 Vote

UNION removes any existing duplicates?

15th Feb 2016, 8:49 PM

Kevin Kiambe

sql union

0 Votes

Is a table similar to a file?

15th Feb 2016, 4:00 AM

Manish maharjan

1 Vote

How to perform join with update query?

14th Feb 2016, 1:34 AM

Kevin Kiambe

join sql update

0 Votes

IN or OR, Which one has better performance?

11th Feb 2016, 4:58 PM

Mushtaq M A

0 Votes

Will you be able to solve this question in SQL?

10th Feb 2016, 6:56 PM

Marcos Ramos

0 Votes

I don't understand using of group by

9th Feb 2016, 7:16 AM

Meri

3 Votes

9th Feb 2016, 7:12 AM

Meri

is OR and IN same?

Can i installed the SQL on my smartphone?

3 Votes

7 Answers

8th Feb 2016, 1:32 PM

Chirag Ramkrushna Bharambe

0 Votes

using BETWEEN and >= AND <= are the same right? the BETWEEN operator includes the values listed and everything between them, yes?

4th Feb 2016, 6:05 AM

Shubham Sain

-1 Vote

someone knows a free options on internet to practice SQL?...if so, may you share the link?. thanks in advance.

1st Feb 2016, 3:09 PM

andre paige

functions sql

0 Votes

I am confuse about fully qualified name can anyone explain?

31st Jan 2016, 7:33 PM

Enrique Valdes

0 Votes

describe timestamp ????? but most simply words and examp??

30th Jan 2016, 3:39 PM

suvidha chourasia

0 Votes

Is SQL a language like java or c?

25th Jan 2016, 4:07 PM

Syed Asad Raza

0 Votes

Can I put utf-8 characters in VARCHAR data type ?!

23rd Jan 2016, 11:23 AM

Ankit S.Mahindre

0 Votes

What is the diffrence between unique and primary key constraints?

20th Jan 2016, 10:46 PM

Reza Pouya

0 Votes

What is the difference between double and float?

19th Jan 2016, 2:10 PM

Aakash Bidlan

0 Votes

With the help of UNION, can we diplay data from 3 different tables..?

18th Jan 2016, 7:44 PM

Sharon Chen

sql union

0 Votes

What sql server you prefer?

18th Jan 2016, 5:18 PM

shrikant pol

0 Votes

How can you store videos in a sql?

17th Jan 2016, 4:46 PM

Mgr. Peter Chriašteľ

0 Votes

Can I import data from a XML file into a table in SQL?

15th Jan 2016, 4:48 PM

Tafadzwa Hopewell Chikuruwo

0 Votes

Can someone define what an aggregate function is?

15th Jan 2016, 4:33 AM

Ennio Politi Lopes

functions sql

1 Vote

Can I have any example on blob data type?

14th Jan 2016, 4:35 PM

Alan Wong

0 Votes

Is there any difference between innested select and wievs?

13th Jan 2016, 9:49 AM

Gaurav Garg

sql views

0 Votes

What is sql>commit; can anybody explain

10th Jan 2016, 2:56 PM

hackeroromis

0 Votes

Lets say I have created a view and I have forgotten the name i used for that particular view but I urgently need to update the query for the view. Is there a way to see all the views I have created so far? so as to help me identify the view that needs to be updated.

10th Jan 2016, 12:07 PM

Abdul Rawoof

sql views

1 Vote

What is the difference in performance when using the full name and just the name of the column?

8th Jan 2016, 1:50 AM

Nana Qhuacy

0 Votes