write sql program to get the detail of student in a class?
Answers were Sorted based on User's Feedback
Answer / bhagwat sharma
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 ? | 13 Yes | 0 No |
Answer / 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 |
How do we get current date in SQL Server 2000, Oracle, MS Access?
What is the usage of sign function?
What is thr feature of change data capture?
How to change server name in sql server?
What is the purpose of update statistics and scope_identity() function?
What number sorts of privileges are accessible in sql?
What is Inner Join?
What is field with example?
Explain the phases a transaction has to undergo?
How to get the definition of a view out of the sql server?
What is a heap?
Explain data warehousing in sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)