Register Now

Login

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Category : SQL

SQL related questions

Question
You have data of people having applied for a lottery ticket. The data consists of their name and ticket number. You have to choose winners by selecting the people present in the alternate rows (first winner starting from row number ...
in progress 4
55 years 21 Answers 6050 views Great Grand Master

Question
Write a query for collecting the names of children who pursuing their graduation in their residential city. NAME AGE ADDRESS COLLEGE ……. …… ….. ….. (Hint- Look for the common city name in the columns of ADDRESS and COLLEGE) Example Nitin 26 Patna Patna Ankit 27 Bangalore Pune Result - Nitin
in progress 4
55 years 20 Answers 6020 views Great Grand Master

Question
Sometimes you are not given a problem, but are asked to create one along with the solution. You will understand this concept through the next question. What is the function of OFFSET command? You might know the definition but create a ...
in progress 1
55 years 5 Answers 2318 views Great Grand Master

Question
NAME SALARY Date of Joining Angad 50,000 05 July Bhuvan 52,000 19 March Danish 77,000 06 September Manhar 64,000 15 May Shivraj 50,000 10 July Tanuj 55,000 13 August You are supposed to provide a salary raise to the employees who have joined after the 31 June. Collect the names of the employees who satisfy the condition.
in progress 1
55 years 7 Answers 2433 views Great Grand Master

Question
NAME SALARY Date of Joining Angad 50,000 05 July Bhuvan 52,000 19 March Danish 77,000 06 September Manhar 64,000 15 May Shivraj 50,000 10 July Tanuj 55,000 13 August   Get the details of the employees whose "FirstName" does not start with any of the characters between 'c-r'
in progress 0
55 years 7 Answers 1846 views Great Grand Master

Question
NAME SALARY Date of Joining Angad 50,000 05 July Bhuvan 52,000 19 March Danish 77,000 06 September Manhar 64,000 15 May Shivraj 50,000 10 July Tanuj 55,000 13 August   How will you get the data of the Nth highest salary from the table? Also, find the third highest salary by substituting values of N.
in progress 1
55 years 10 Answers 2500 views Great Grand Master

Question
NAME SALARY Date of Joining Angad 50,000 05 July Bhuvan 52,000 19 March Danish 77,000 06 September Manhar 64,000 15 May Shivraj 50,000 10 July Tanuj 55,000 13 August   Get all the employee detail from Employee Detail table whose "FirstName" starts with A and contain 5 letters.
in progress 0
55 years 4 Answers 1610 views Great Grand Master

Question
Write a suitable query where you will collect the names of visitors in a conference who have less than 8 characters in their name. Also, separate the ones with a middle name. (Hint- You can take appropriate column_names)
in progress 1
55 years 6 Answers 1868 views Great Grand Master

Question
How can you create an empty table from an existing table? Write the steps and explain the working. Take the following table for instance and create a new table named as cstudent. NAME MARKS ROLL NUMBER Ashutosh 87 1001 Bhavya 92 1002 Garima 69 1003 Pratham 75 1004 Sushant 90 1005
in progress 1
55 years 6 Answers 2596 views Great Grand Master

Question
Write an SQL Query find number of employees whose DOB is between 01/07/1965 to 31/12/1975. Collect the data separately for different gender. Use column name as sex, DOB table name Employees. (Hint- Imagine a hypothetical data)
in progress 3
55 years 6 Answers 2427 views Great Grand Master