Home
Q&A
Education
Technology
Credit
General
Health
Insurance
Questions
Ask a Question
Recent questions tagged Sql
0
votes
Q: Difference between JOIN and INNER JOIN
Both these joins will give me the same results: SELECT * FROM table JOIN otherTable ON table.ID = ... different SQL implementations? Select the correct answer from above options...
asked
Jan 28, 2022
in
Education
by
JackTerrance
sql
sql-server
join
inner-join
0
votes
Q: How to return only the Date from a SQL Server DateTime datatype
SELECT GETDATE() Returns: 2008-09-22 15:24:13.790 I want that date part without the time part: 2008-09-22 00: ... How can I get that? Select the correct answer from above options...
asked
Jan 28, 2022
in
Education
by
JackTerrance
sql
sql-server
tsql
date
datetime
0
votes
Q: How do I perform an IF…THEN in an SQL SELECT?
How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR ... Saleable, * FROM Product Select the correct answer from above options...
asked
Jan 28, 2022
in
Education
by
JackTerrance
sql
sql-server
tsql
if-statement
case
0
votes
Q: Insert results of a stored procedure into a temporary table
How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [ ... not supply any columns. Select the correct answer from above options...
asked
Jan 28, 2022
in
Education
by
JackTerrance
sql
sql-server
sql-server-2005
tsql
stored-procedures
0
votes
Q: How to concatenate text from multiple rows into a single text string in SQL server?
Consider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this into ... Peter, Paul, Mary? Select the correct answer from above options...
asked
Jan 28, 2022
in
Education
by
JackTerrance
sql
sql-server
csv
string-concatenation
group-concat
0
votes
Q: Finding duplicate values in a SQL table
It's easy to find duplicates with one field: SELECT name, COUNT(email) FROM users GROUP BY email HAVING COUNT( ... to find them first. Select the correct answer from above options...
asked
Jan 28, 2022
in
Education
by
JackTerrance
sql
duplicates
0
votes
Q: How to query MongoDB with “like”?
I want to query something with SQL's like query: SELECT * FROM users WHERE name LIKE '%m%' How to do I ... like in the documentation. Select the correct answer from above options...
asked
Jan 26, 2022
in
Education
by
JackTerrance
sql
mongodb
mongodb-query
sql-like
0
votes
Q: Inserting multiple rows in a single SQL query?
I have multiple set of data to insert at once, say 4 rows. My table has three columns: Person, Id and ... a single SQL statement? Select the correct answer from above options...
asked
Jan 26, 2022
in
Education
by
JackTerrance
sql
sql-server
tsql
insert
0
votes
Q: How do I UPDATE from a SELECT in SQL Server?
In SQL Server, it's possible to insert into a table using a SELECT statement: INSERT INTO Table (col1, col2, ... .id = other_table.id Select the correct answer from above options...
asked
Jan 26, 2022
in
Education
by
JackTerrance
sql
sql-server
tsql
select
0
votes
Q: What is difference between inner join and outer join
Difference between inner and outer join. i am using two table and want to fetch data from both table so which ... can solve our problem Select the correct answer from above options...
asked
Jan 26, 2022
in
Education
by
JackTerrance
sql
join
Page:
« prev
1
2
3
4
5
...