write sql program to get the detail of student in a class?
Answer Posted / muruga nandhini.p
create table student
(
roll_no int,
name varchar(20),
class int,
address varchar(50),
phone int
)
++++++++++++++++run select than press f5
insert into student values(1,'Bhagwat',10,'Mathura',9268450493)
+++++++++++++run select than press f5
select * from student where roll_no=1
+++++++++++++++++++++++++++run select than press f5
Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
what are different types of raid configurations? : Sql server database administration
What is a field in a table?
How to convert binary strings into integers in ms sql server?
What is a join in sql?
How can I change procedure name in sql server?
How many columns can exist together per table?
How to send a ssrs report from ssis?
What are Spatial data types in SQL Server 2008
How to Check if table exists in sql server?
Do you know what is blocking?
How to enable/disable indexes?
What are “unrepeatable reads”?
Does server sql treat char as a variable-length or fixed-length column?
What is tablix?