Explore tweets tagged as #SQLforDataScientist
Write a Query to get Unique Grade without using DISTINCT keyword. #sqlinterviewquestionsandanswers.#sql.#sqlqueries.#SQLforDataScientist.#LearnSQL.#LearnSQLqueries.#SQLtips.#DataMillennials.#SQLtricks.#distinctrecords.#sqldistinct.#sqluniquerows.#distinct
0
0
0
What is the difference between UNION and UNION ALL?. #sqlinterviewquestionsandanswers.#sql.#sqlqueries.#SQLforDataScientist.#LearnSQL.#Union.#SQLtips.#DataMillennials.#SQLtricks.#SQLDataMillennials.#sqlunion.#unionall.#sqlunionall
1
0
2
Find min column value without using MIN function. #sqlinterviewquestionsandanswers.#sql.#sqlqueries.#SQLforDataScientist.#LearnSQL.#LearnSQLqueries.#SQLtips.#DataMillennials.#SQLtricks.#SQLDataMillennials.#sqlminfunction.#minfunction.#sqlmin.#min
0
0
0
Write Query to find employees with duplicate email. #sqlinterviewquestionsandanswers.#sql.#sqlqueries.#SQLforDataScientist.#LearnSQL.#duplicaterows.#SQLtips.#DataMillennials.#SQLduplicaterows.#SQLDataMillennials.#duplicate
0
0
0
Write SQL Query to find duplicate rows in a database?. #sqlinterviewquestionsandanswers.#sql.#sqlqueries.#SQLforDataScientist.#LearnSQL.#LearnSQLqueries.#SQLtips.#DataMillennials.#SQLtricks.#SQLDataMillennials.#duplicate.#sqlduplicaterows
1
0
0
Write SQL query to delete duplicate rows in a table?. #sqlinterviewquestionsandanswers.#sql.#sqlqueries.#SQLforDataScientist.#LearnSQL.#SQLqueries.#SQLtips.#deleteduplicate.#DataMillennials.#SQLtricks.#sqldeleteduplicate.#sqldelete.#Delete
0
0
0
Write 2 query to get the first 3 character of a string. #sqlinterviewquestionsandanswers.#sql.#sqlqueries.#SQLforDataScientist.#LearnSQL.#LearnSQLqueries.#SQLtips.#DataMillennials.#SQLtricks.#leftofstring.#leftfunction.#sqlleft.#character
1
0
0
What is Sub Queries and Write a simple Example of Subquery. #sqlinterviewquestionsandanswers.#sql.#sqlqueries.#SQLforDataScientist.#LearnSQL.#LearnSQLqueries.#SQLtips.#DataMillennials.#SQLtricks.#SQLDataMillennials.#sqlsubqueries.#subqueries.#innerqueries
0
0
1
Write a query to create an empty table from an existing table?. #sqlinterviewquestionsandanswers.#sql.#sqlqueries.#SQLforDataScientist.#LearnSQL.#LearnSQLqueries.#SQLtips.#DataMillennials.#SQLtricks.#emptytable.#emptysqltable.#createemptytable.#blanktable
0
0
0
What is the efficient way in SQL for writing If/Else statements?. #sqlinterviewquestionsandanswers.#sql.#sqlqueries.#SQLforDataScientist.#LearnSQL.#LearnSQLqueries.#SQLtips.#DataMillennials.#SQLtricks.#sqlifelse.#Case.#ifelse
0
0
0
What is the difference between where clause and having clause?. #sqlinterviewquestionsandanswers.#sql.#sqlqueries.#SQLforDataScientist.#LearnSQL.#sqlhaving.#SQLtips.#DataMillennials.#having.#SQLtricks.#SQLwhere.#where
0
0
1
What is the main difference between RANK & DENSE_RANK functions in SQL. #sqlinterviewquestionsandanswers.#SQL #sqlrank.#sqldenserank.#rank.#sqlquerie.#denserank.#SQLforDataScientist.#LearnSQL.#LearnSQL.#SQLtips.#DataMillennials.#SQLtricks.#rankvsdenserank
0
0
0
Write SQL Query to get Student Name and number of Students in same grade. #sqlinterviewquestionsandanswers.#sql.#sqlqueries.#SQLforDataScientist.#LearnSQL.#LearnSQLqueries.#SQLtips.#DataMillennials.#SQLtricks.#SQLDataMillennials.#groupby.#sqlgroupby
0
0
0
How to find out the number of player who scored the goal and who has not scored the goal. #sqlinterviewquestionsandanswers.#sql.#sqlqueries.#SQLforDataScientist.#LearnSQL.#LearnSQLqueries.#SQLtips.#DataMillennials.#SQLtricks.#SQLData.#sqlfunction
0
0
0
Write SQL Query to get Employee Name, Team_Leader_ID and number of employees in the department?. #sqlinterviewquestionsandanswers.#sql.#sqlqueries.#SQLforDataScientist.#LearnSQL.#LearnSQLqueries.#DataMillennials.#SQLtricks.#SQLgroupby.#sqlcount.#groupby
0
0
0
Write a query to get rows values a comma separated list based on the other columns same value. #sqlinterviewquestionsandanswers.#sql.#sqlqueries.#SQLforDataScientist.#LearnSQL.#LearnSQLqueries.#SQLtips.#DataMillennials.#SQLtricks.#comma.#commaseperated
0
0
0
Write a Query to find all Employees whose name contains the char “sh, regardless of case. E.g. SH, sh, Sh,sH. #sqlinterviewquestionsandanswers.#sql.#sqlqueries.#SQLforDataScientist.#LearnSQL.#SQLtips.#DataMillennials.#SQLtricks.#wildcards.#sqllike.#like
0
0
0
Write a single SQL query to change the department name from DeptID 1 to 2 & change department name from DeptId 2 to 1. #sqlinterviewquestionsandanswers.#sql.#sqlquerie.#SQLforDataScientist.#LearnSQL.#queries.#SQLtips.#DataMillennials.#SQLtricks.#SQLupdate
0
0
0
Write Query to find employees with duplicate email. #sqlinterviewquestionsandanswers.#sql.#sqlqueries.#SQLforDataScientist.#LearnSQL.#duplicaterows.#SQLtips.#DataMillennials.#SQLduplicaterows.#SQLDataMillennials.#duplicate
0
0
0
Write a Query to find all Employees whose name contains the char “sh", regardless of case. E.g. SH, sh, Sh,sH.#sqlinterviewquestionsandanswers.#sql.#sqlqueries.#SQLforDataScientist.#LearnSQL.#SQLtips.#DataMillennials.#SQLtricks.#wildcards.#sqllike.#like
0
0
0