python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - select

Selecting fields from multiple tables with Where and Substr

Not sure what I'm doing wrong here. I've been trying all week and can't find the problem. I'm new to oracle so I'm hoping it's something easy I'm missing. My script is below. I'm trying to pull stu...
test-img

user17986852

sql

oracle

select

where-clause

substr

Votes: 0

Answers: 1

Latest Answer

There is a stray || after t.email_addr, and the line with '' before the FROM clause shouldn't be there. select s.student_number||','|| s.first_name||','|| s.last_name||','|| s.schoolID...
test-img

William Robertson

MySQL how to reverse where?

I have a table like this id path 1 / 2 /a/ 3 /a/b/ 4 /a/b/c/ 5 /a/b/c/d When I use a path (e.g., path = '/a/b/c/') in the where clause, I would like to retrieve the children of thi...
test-img

Carlo Jimenez

php

mysql

select

Votes: 0

Answers: 2

Latest Answer

You could use the instr function SELECT * FROM mytable WHERE INSTR('/a/b/c', path) = 1
test-img

Mureinik

SQL - spliting one column to two separated (diffrent condition)

I don't know how to split one column to two separated with diffrent condition. If contact is type == 'E' would like save AS email, otherwise type == '6' save AS phone. I need result like this:
test-img

Marcel Golob

mysql

sql

select

Votes: 0

Answers: 3

Latest Answer

You want CASE expression select *, case when type = 'E' then contact end email, case when type = '6' then contact end phone from KONTAKTI
test-img

Serg

How to equally split the results of MYSQL?

Let's say I write a SELECT statement in MYSQL(version MySQL 8.0) which fetches "n" records. I want this "n" records be split approximately equally by 3 and additionally need to mak...
test-img

nikviz

mysql

sql

select

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs