Q&A Discussions

select round( sysdate, month) from dual; in this query if we use number instead of sysdate.. it shows error.. why?

27th Jul 2022, 4:55 AM

Avinash Tiwari

0 Votes

I have made a table employee where are 2 employee having same designation what command or query i should use to show name & id

4th Oct 2016, 7:08 PM

S.Akbar Sheriff

0 Votes

I need help from a very experimented programer. I need a form that lets to the web visitor make all query he wants on my db

21st Oct 2019, 8:01 PM

Disha Dey

database mysqli php

2 Votes

Sometimes sql query depends upon database used...for example oracle does not support LIMIT clause whereas mySQL does.Is it true??correct me if i am wrong.

3rd Apr 2017, 4:00 PM

Fausto Gutman

0 Votes

Group by Time as varchar every 30 min

9th Sep 2016, 8:01 AM

Vipul Newaskar

db oracel query

0 Votes

23rd Mar 2020, 12:17 PM

Ghaida

What is the use of SQL ?

data language query

-3 Votes

Write a query to output the apartments whose prices are greater than the average and are also not rented, sorted by the 'Price'.

29th Apr 2020, 10:47 AM

narayanapuram harikrishna

-6 Votes

Do we can use superscript and subscript in oracle and sql? If yes then what is the query for it.

14th Sep 2022, 4:05 AM

Mohit Namdev

oracle sql

1 Vote

Share the languages you all know so that everybody can interact better and can feel proud of you.

18th Jan 2017, 7:28 AM

Deepika Behera

coding colleagues friend programming query sololearn

7 Votes

10 Answers

7th May 2017, 8:47 AM

Vishnu ks

Why am I unable to unlock new lessons?

beginner doubt learner practice query

2 Votes

Query the list of CITY names have vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.

23rd Apr 2022, 11:09 AM

Vaibhavi

0 Votes

How to create/write a SQL query to find the salesperson and customer who belongs to same city. Return salesman, cust_name&city

19th Dec 2016, 9:57 AM

Akwin Lopez

lauren

-1 Vote

If I was given 6enteries to a row and and if I need to add in middle of the table what query I must use?

4th Mar 2022, 1:55 AM

Lauren Terez

insert sql

0 Votes

Тoday a customer want a cake set that has minimal calories. Write a query to sort the cakes by calorie count and select the fir

5th Aug 2016, 4:47 PM

sriram muralidharan

-1 Vote

To find the names of the customers between 30 to 40 years of age, set up the query as seen here:

20th Apr 2022, 1:19 PM

Drex 1

recode

0 Votes

Which should be preferable considering query cost ? joins should be used in sql queries OR Inner query(sub queries) is best.

3rd Apr 2018, 5:27 AM

Yiwen Zhao

php sql subqueries

1 Vote

20th Oct 2017, 7:04 PM

Shaikh Mehboob Siraj

Projects? Meaning?

projects python query

0 Votes

Hi! Can you suggest me a way to learn about Databases and SQL Language? At school I study this , but I have more difficult...

17th Dec 2016, 12:35 PM

Ateeb Ahmed

beginners database query sql

0 Votes

How do i connect to a database, all my php codes are ready but i thing i have little problem with the query

5th Dec 2019, 9:07 PM

Niko

localhost.mysql,phpmyadmin,

0 Votes

Hi I want to use media query in css in div element to resize it's height according to device. Can anyone send me whole process?

18th Jun 2017, 8:59 PM

SkyeTech

css

0 Votes

What is the problem in the below code? Why don't I get the output? Also tell why when I view this in browser I see blank Webpage

6th Oct 2020, 5:18 PM

Ajay Rai

php programming query sololearn

2 Votes

friends, my head is loaded..can u plz remind me where i can find @media query lessons, is it in html5 or css?...i just can't get

13th May 2017, 1:33 PM

Vishnu ks

0 Votes

Can sme1 give me the command to this query Get the first name, city, country, and invoiced amount of customers living either in Brazil or in Paris and with a total invoice greater than $38.

3rd May 2017, 3:55 PM

Kelvine De Danielo

sql where

1 Vote

12 Answers

13th Sep 2016, 6:20 PM

Freeman Phiri

Need to write a query that returns the total profit made from 1Q of 2011- 4Q of 2016 in PgAdmin(sql). How do i go about this?

coding postgres query sql

0 Votes

Write a query to output all teams which conceded the least number of goals in the league ordered by scored goals in descending??

23rd Aug 2020, 3:35 PM

Chudyn

-4 Votes

write sql query if you are given a schema of two table named Customers and Orders, you should select the Name of all customers w

26th May 2021, 1:31 PM

saffadya devan

customer jquery orders sql

0 Votes

Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.

25th Aug 2022, 12:29 PM

Navnath Bulkunde

0 Votes

When we perform Arithmetic Operation in SELECT query It also reflect to our original DATABASE or it only Display the result (i.e

11th Nov 2022, 5:27 PM

Muruga Perumal

database query sql

0 Votes

I can see a several languages over here.How Are They Different from each other? Like some are programming languages, query lang.

8th Oct 2016, 6:08 AM

Pranay Neema

c++java language query scripting

1 Vote

Can we overload Main method in Java? And what if if did overload it i.e. from which method the main thread will start from?

11th Sep 2017, 2:58 AM

Ishu Maurya

java main methods query

1 Vote

Please am urgently in need of an ExpressJS developer for a clarification on how to create an endpoint that accepts query string

21st Nov 2017, 6:34 PM

Riyashi Chandak

expressjs

0 Votes

php variable into mysql database

10th Jan 2021, 5:38 PM

kemzy

button database favorites html php query

0 Votes

9 Answers

2nd Jul 2020, 8:57 PM

newbiecoder

Date before 1980 (SQL)

date mysql programming query sql tables

0 Votes

6 Answers

16th Nov 2020, 11:28 PM

Kevin

What is the best way to import a sql file into a js file by node and how to use sql file query in the js file

node.js sql

1 Vote

10th Jun 2020, 9:17 PM

Arsham Aazami

Software for SQL

dbms query software sql

1 Vote

How to fetch data selecting radio button in php??

1st Jul 2020, 6:23 AM

Isha Shekh

html php query sql

1 Vote

Sum value from every 4 months

7th Jun 2017, 4:11 PM

Sultan Belai

functions query sql sum

0 Votes

I am about to complete introduction to HTML ,I am from non IT background ,what should i do next

9th Nov 2017, 4:38 AM

Himas Adin Nugroho

confused doubt it non query

0 Votes

Is it worth getting the Pro version?

27th Dec 2022, 11:07 AM

Kamil Dhanani

beginner help query support

0 Votes

write SQL query for following To list all the columns of the table 'employee' in ascending order of department number and descending order of salary.

26th Apr 2020, 12:56 AM

Md. Niamul Ahad Chowdhury

1 Vote

Query the Name of any student in STUDENTS who scored higher than Marks. Order your output by the last three characters of each

15th Dec 2016, 4:18 PM

DHEERAJ

0 Votes

hi i want to order a commend with exec() and show results with j query and ajax how i can do ?

19th Dec 2016, 9:34 AM

Akwin Lopez

ajax exec jquery php

0 Votes

is view memory intensive as the note in the end mentions it recreates every time a query on view is made ?

21st Oct 2016, 7:43 AM

mohammad reza khodami

sql views

0 Votes

28th Aug 2016, 10:17 PM

rjamakai

Where am I going wrong??

join mysql query sql

0 Votes

Write a query in SQL that uses a random number generator to create a variable integer to determine the amount of rows selected.

4th Aug 2022, 9:59 PM

Shiva Shankari Rajaram

query rng sql variables

0 Votes

27th Jan 2017, 6:11 PM

Andre van Rensburg

[SOLVED] Sololearn Pro

currency nok pro query sololearn solved

1 Vote

How this code executes : 4 ?

13th Jul 2020, 3:19 PM

Emanuel Maliaño

code if java loop query while

2 Votes

Why don't you provide sql editor to practice us. Plzz provide sql command prompt so that i could write query by my own or check

10th Sep 2018, 4:50 AM

Abhishek Shirawale

sal

0 Votes

What will happen if we run a for loop outside an infinite for loop?

14th Feb 2019, 2:01 PM

oshi Agrawal

answer challenges python query

0 Votes