Discover
Questions library
Collections library
Find online teacher
login
Discover
questions library
Find online teacher
login
Popular searches:
if-else
class-diagram
flowchart
Polymorphism
Home
Questions
Questions
Study lists
Yasmin Questions
5728 Questions
Write a query to create a clone of existing table without using Create Command.
Database
Sql programming
2022-05-13
Answers
30
Question
40
Followers
30
0
1
567
How to select random record form a tblstudent.
Database
Sql programming
2022-05-13
Answers
30
Question
40
Followers
30
0
1
570
Write a query to find out the studentname who has not received any scholarship amount, and display 0 in front of his name.
Database
Sql programming
2022-05-13
Answers
30
Question
40
Followers
30
0
1
550
Select FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even if they didn’t get Scolarship amount and set Scolarship amount as 0 for those students who didn’t get Scolarship amount.
Database
Sql programming
2022-05-13
Answers
30
Question
40
Followers
30
0
1
604
Select FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for those students who got Scolarship amount using right join.
Database
Sql programming
2022-05-13
Answers
30
Question
40
Followers
30
0
1
558
Select FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for those students who got Scolarship amount greater than 1200.
Database
Sql programming
2022-05-13
Answers
30
Question
40
Followers
30
0
1
522
Select FirstName, Lastname, Scholarship amount from tblStudent and tblScolarship table for those students who got Scolarship amount.
Database
Sql programming
2022-05-13
Answers
30
Question
40
Followers
30
0
1
574
Select FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even if they didn’t get Scolarship.
Database
Sql programming
2022-05-13
Answers
30
Question
40
Followers
30
0
1
1080
Select no of students joined with respect to year and month from tblStudent table.
Database
Sql programming
2022-05-13
Answers
30
Question
40
Followers
30
0
1
516
Get branch, no of students in a branch, total admission fees with respect to a branch from tblStudent table order by admission fees descending.
Database
Sql programming
2022-05-13
Answers
30
Question
40
Followers
30
0
1
469
Get branch wise minimum admission fees from “tblStudent” table order by admission fees ascending order.
Database
Sql programming
2022-05-13
Answers
30
Question
40
Followers
30
0
1
994
Get branch wise maximum admission fees from “tblStudent” table order by admission fees descending order.
Database
Sql programming
2022-05-13
Answers
30
Question
40
Followers
30
0
1
733
Get branch wise average admission fees from “tblStudent” table order by admission fees ascending order.
Database
Sql programming
2022-05-13
Answers
30
Question
40
Followers
30
0
1
798
Total:
5728
Previous
357
358
359
360
361
Next
Go